Forum Discussion
Excel formula Help
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.
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
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.
Ah re-doing my graphs and using v lookups worked so much better, thank you sooo much!
:) glad it worked out.