Forum Discussion
VLOOKUP against two columns
milo1234 Combine VLOOKUP with INDEX and MATCH and use structured tables in Sheet1 as well.
See attached.
milo1234 Combine VLOOKUP with INDEX and MATCH and use structured tables in Sheet1 as well.
See attached.
This is my formula which displays an error message:
=INDEX(Teams,MATCH([@[EpicName*]],Teams[Team],0),MATCH(VLOOKUP([@WP]],Sizes,2,FALSE),Teams[#Headers],0))
I have renamed the legend table 'Teams' and the T-shirt size table 'Sizes'
milo1234 Difficult to diagnose with the file on hand, but try this:
=INDEX(Teams,MATCH([@EpicName*],Teams[Team],0),MATCH(VLOOKUP([@WP]],Sizes,2,FALSE),Teams[#Headers],0))
Otherwise, that the file I sent, change the table names and column headers how you have them in your actual file and see how the formula looks like then.
- It doesn't like the Teams[#Headers] section. This is highlighted as the error.
