Forum Discussion
Solved
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.
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.
milo1234 Can't help if you don't upload the file. Sorry!
- I managed to get it working, thank you.
My 'Sizes' table was not being picked up.