All,
I have scoured the internet trying to find an answer, but with no success.
The problem: I have table of people and their preferences. I want to validate that a preference exists for that person. Vlookup and Hlookup are useless as both the rows and columns are dynamic.
To illustrate, here is an example table:
Column 1 Column 2 Column 3 Column 4
Name Pref 1 Pref 2 Pref 3
John Flowers Apples Trucks
Cindy Cars Reading Food
I have a list of preferences and when I put in their name, I want it to validate that they have that preference listed:
Preference Name Exists?
Apples John Yes
Apples Cindy No
I have tried using various combinations of index and match, but I can't seem to get one to work.
Please help!
Thanks!
Scottymagic
Bookmarks