Forum Discussion
Solved
Lookup & Match from separate table
Hi All, I need to check a lookup table to choose the category. Column A has list of values (some duplicate names) and text search on the column A values gave multiple categories.. i have values in li...
Hi, chem094
Based on the information above, what you want to achieve is to return the highest parent category in the parent-child hierarchy.
Please use the solution I provided in the other thread you posted.Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-angzheng-msft
Community Support
Community SupportHi, chem094
Based on the information above, what you want to achieve is to return the highest parent category in the parent-child hierarchy.
Please use the solution I provided in the other thread you posted.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.