Vlookup with multiple criterias in Excel

Hi reader,

How many times have you wonder how to make Vlookup with multiple selection? In the bellow example you will find the solution:

You have a match record table (table F3:I14) and your aim is to find the match result on it (e.g.  Brazil x Belgium, table A3:C4) :

• use the formula "=INDEX(table_to_search;MATCH(1st Criteria&2nd Criteria;Column to search 1st Criteria&Column to search 2nd Criteria;0);Column with output value)"
• press ctrl + shift + enter keys
• where:
• table_to_search: F3:I14
• 1st Criteria: A4
• 2nd Criteria: B4
• Column to search 1st Criteria: F3:F14
• Column to search 2nd Criteria: G3:G14
• Column with output value: 4 (e.g. "Result" - forth column of the table_to_search)

Hope it makes your spreadsheets easier.