Excel formula Help

[Brianda Figueroa]

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 to return on column D are the lists of categories. I have many categories...about 16 lists (as tables) with about 1-25 specific texts. 

[#2]

Can you upload an example of what you are trying to do? It sounds like something you can solve with an index(match()) but it would be good to see exactly what you are trying to achieve.

[#3]

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

[#4]

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.

[#5]

Ah re-doing my graphs and using v lookups worked so much better, thank you sooo much! 

[#6]

:) glad it worked out.