Forum Discussion
Brianda Figueroa
Aug 07, 2018Copper Contributor
Excel formula Help
Hello, I am trying to write a formula for column D that returns texts if the text in column C falls under a list of items. Basically, the texts in column C are specifics and the text I am trying...
Brianda Figueroa
Aug 07, 2018Copper Contributor
Hi Philip,
Thanks for responding!
I attached a simplified form of my file! Let me know if you have any other questions!
I am trying to get column B - Product family to return "Fruits" for A2 etc
Philip West
Aug 08, 2018Iron Contributor
Do your look up tables have to be arranged like that? If you were to have 1 table, that had columns for Category and Family to look up against this becomes really easy with an index(match()) or you could do it with a vlookup if that's your preference.
I've attached an example of what I mean.
- Brianda FigueroaAug 08, 2018Copper Contributor
Ah re-doing my graphs and using v lookups worked so much better, thank you sooo much!
- Philip WestAug 08, 2018Iron Contributor
:) glad it worked out.