May 01 2019 07:35 AM
May 01 2019 07:48 AM
@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.
May 01 2019 12:12 PM
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 )
May 05 2019 11:41 AM