Forum Discussion
Lookup & Match from separate table
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.
Super UserHow are you grouping the products in column A? How do we know "Laptop Co Pub limited" and "Laptop Dell Corp" are different groups but "Laptop Co Pub limited" and "Laptop Univ" are in the same group?
if you see in above table, i have one institution with 3 valid keywords, using keywords i mapped to all the categories. but in final category should be "Ëducation" using hierarcy table. So, education should be filled in all the 3 lines in final category column this duplicates can be removed at end stage based on institution name and finalcategory.