Forum Discussion
VLOOKUP against two columns
Hi,
Please find sample data attached.
I want to fill column C in Sheet2, using the information on Sheet1, however I am unsure how to use a VLOOKUP with two criteria's.
milo1234 Combine VLOOKUP with INDEX and MATCH and use structured tables in Sheet1 as well.
See attached.
6 Replies
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.
