Forum Discussion
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/...
If you are willing to create a lookup table AND sort it by food then it is possible to use an old function
= LOOKUP( [@Food], FoodGroup )
- Thank you! I'm not that good with excel, I try to follow the steps for using formulae but always seem to go wrong somewhere!
