Forum Discussion
Wee_Maggie
May 01, 2019Copper Contributor
Multiple IF commands
If I have a list of foods in column A like apple, yoghurt, pear, potato etc and want to return those foods in column B as their group like fruit, veg, dairy, carb etc what would I use? Would it be IF/...
SergeiBaklan
May 01, 2019Diamond Contributor
Wee_Maggie , it's better to have separate table where you define what is in which group, and after that INDEX/MATCH or VLOOKUP into column B values from A based on this table.
Wee_Maggie
May 01, 2019Copper Contributor
Thank you! I'll give that a go!