How to VLOOKUP with multiple criteria in Excel and Google Sheets

Excel & Google Sheets

=INDEX(C:C, MATCH(E2&F2, A:A&B:B, 0))

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

Step by step

1Join your lookup values with &: E2&F2.
2Match that against the two key columns joined the same way: A:A&B:B.
3INDEX returns the matching row from the result column C:C.

Tips

In older Excel (pre-365), confirm the formula with Ctrl+Shift+Enter so the joined range evaluates as an array.
A simpler alternative: add a helper column =A2&B2, then VLOOKUP the combined key.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Frequently asked

Can VLOOKUP match on two columns?

Not directly. Either add a helper column that joins the keys, or use INDEX/MATCH with the keys joined by & as shown above.

More on VLOOKUP

VLOOKUP

Look up a value in the first column of a range and return a value from another column in the same row.

How to VLOOKUP from another sheet

Pull a value from a different tab with VLOOKUP by prefixing the range with the sheet name. Works in Excel and Google Sheets.

Fix #N/A

Fix #N/A errors in VLOOKUP in Excel and Google Sheets — covers missing matches, extra spaces, data-type mismatches, and range mistakes.

How to fix VLOOKUP returning #N/A

VLOOKUP shows #N/A when it can’t find a match. Here are the real causes — exact-match, spaces, text-vs-number — and how to fix each.

Fix Wrong value

VLOOKUP returns an incorrect value in Excel and Google Sheets — fix wrong column index, approximate match mode, unsorted data, and duplicate lookup keys.

XLOOKUP vs VLOOKUP: which to use

XLOOKUP looks in any direction, defaults to exact match, and has a built-in not-found value. Here is when to use each over VLOOKUP.

Formulas used

INDEX / MATCH VLOOKUP XLOOKUP

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026