FormulaCraft

How to VLOOKUP with multiple criteria in Excel and Google Sheets

Topic:VLOOKUP
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

Runs server-side · free · no signup

Step by step

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

Tips

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

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

See all →
Reference

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

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.

Error fix

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

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.

Error fix

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.

How-to

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 / MATCHVLOOKUPXLOOKUP

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

Last reviewed: