How to do a Vlookup with Multiple Criteria

In this Excel tutorial you will learn how to do a vlookup with multiple criteria in Excel. When doing the VLOOKUP with multiple conditions, different things matter.

There will be different things that make it possible to do the lookup.

But, this start with having a data like this:

VLOOKUP two criteria data table

Inserting a concatenate formula

1. Click on column A, Right Click on it (1), and choose Insert (2).

VLOOKUP two criteria right click insert

2. Click on the new column, right beside Adam (1), type =CONCATENATE(B6;C6) (2), and double click on the small square that is on right lower corner of the result (3).

concatenate formula

Inserting Vlookup formula

3. Write the two Criteria (in this case, name) in respective cells. Note: The Tony and Olson written in their respective cells are the two criteria that we will use the VLOOKUP function to find.

VLOOKUP two criteria  write two criteria

4. Click on an empty cell, and then type in =VLOOKUP(B3&C3;$A$5:$E$10;5;FALSE).

VLOOKUP two criteria click empty cell