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.

Using CONCATENATE for Multiple Criteria VLOOKUP

Data Preparation

Begin with a dataset containing multiple columns, including the criteria you want to match.

VLOOKUP two criteria data table

Inserting a Concatenate Formula

Insert a new column by right-clicking on an existing one.

VLOOKUP two criteria right click insert

In the newly inserted column, create a concatenate formula using the CONCATENATE function (e.g., =CONCATENATE(B6, C6)) to combine the values of the criteria columns for each row.

concatenate formula

Inserting Vlookup formula

In separate cells, enter the specific criteria you want to search for (e.g., “Tony” and “Olson”).

VLOOKUP two criteria write two criteria

In an empty cell, use the VLOOKUP function to search for the concatenated criteria in your dataset. The formula should look like this: =VLOOKUP(B3&C3, $A$5:$E$10, 5, FALSE).

VLOOKUP two criteria click empty cell

Replace “B3&C3” with the cell references containing your criteria.

Adjust the range and column number as needed based on your dataset.

See also  How to Use Database Functions in Excel