Is VLOOKUP faster than INDEX-MATCH?

In our original HyperFormula 3.3.1 benchmark, VLOOKUP was consistently fastest — about 1.65–1.83× faster than INDEX-MATCH and 1.35–1.40× faster than XLOOKUP across 1,000 to 100,000 rows. Results are engine-specific and may differ in native Excel.

Why does my VLOOKUP return #N/A?

#N/A means the lookup value wasn't found in the first column of the range. Check for trailing spaces, mismatched data types (text vs number), or that the lookup column is the leftmost column of the range.

Should I use VLOOKUP or XLOOKUP?

XLOOKUP is more flexible — it can look left, defaults to exact match, and returns custom not-found values. VLOOKUP is simpler and was fastest in our benchmark. Use XLOOKUP when you need leftward lookup or cleaner error handling.

Can VLOOKUP look to the left?

No. VLOOKUP only returns values to the right of the lookup column. For leftward lookup, use INDEX-MATCH or XLOOKUP — both covered in the Pro course.

What does the last argument (0 or 1) do?

0 (or FALSE) means exact match — it finds only an identical key. 1 (or TRUE) means approximate match and requires the first column to be sorted ascending; it returns the closest value not greater than the key.

VLOOKUP Function — Syntax, Examples & Speed Benchmark (2026)

// 01 — Anatomy

How VLOOKUP works

VLOOKUP searches the leftmost column of a range for a key, then returns a value from a column you specify in the same row. "V" stands for vertical.

-- exact match (most common)
=VLOOKUP(lookup_value, table_array,
    col_index_num, 0)

-- example: find salary by employee ID
=VLOOKUP(1042, A2:D500, 4, 0)

Argument	What it does
lookup_value REQ	The key to search for (a value or cell reference).
table_array REQ	The range. The key must be in its first column.
col_index_num REQ	Which column to return (1 = first column).
range_lookup OPT	0/FALSE = exact, 1/TRUE = approximate (sorted).

// 02 — Original data VLOOKUP vs INDEX-MATCH vs XLOOKUP

We benchmarked exact-match lookups in HyperFormula 3.3.1 — median recalculation time across four table sizes. This is original measured data, not republished.

VLOOKUP XLOOKUP INDEX-MATCH

Table rows	VLOOKUP (ms)	XLOOKUP (ms)	INDEX-MATCH (ms)

How we measured · who made this

LookupLab Research · run Nov 2026 · Apple Silicon · HyperFormula 3.3.1 · median of repeated runs

Exact-match lookups on a sorted table, full-column reference, median recalculation time across four table sizes. Every result was correctness-verified before timing. This is directly relevant to web spreadsheet tools and indicative, not identical to native Excel. VLOOKUP was fastest in every size tested.

⬇ Reproduction script (bench.mjs) ⬇ Raw data (bench-hf.json)

Text drafted with AI assistance and edited by LookupLab. Every benchmark number is machine-measured and reproducible, not generated. Data licensed CC BY 4.0.

// 03 — Try it live

Interactive lookup playground

Edit the cells, change the lookup key, switch functions and match modes. The result and the generated formula update instantly.

A1Employee data. Click any cell to edit

Lookup key (ID) 1003

Return column

Function

Match mode

Table rows 8

Grid theme

Highlight match

IFERROR wrap

Fallback value

Result

$62,000

=VLOOKUP(1003,A2:D9,4,0)

✓ foundinstant

// 04 — Error library

The real-world error library

14 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

🔍

// 05 — Cross-platform

Where VLOOKUP works

Availability and syntax differences across desktop Excel, Google Sheets, LibreOffice and the web spreadsheet engines — including the exact-match quirk we found in our benchmark.

Platform	Support	Notes	Gotcha

✓ Supported full VLOOKUP◐ Partial works with caveatsCompiled from public docs · verify against your build

// 06 — Go deeper

🔒

Unlock the full VLOOKUP course

Everything above is free. Go Pro for the deep end.

✓ 200 graded practice problems with instant feedback ✓ INDEX-MATCH vs VLOOKUP deep dive + when to switch ✓ Two-way & leftward lookup patterns ✓ Downloadable workbook + completion certificate

$9/mo $59/yr · save 45% $149 lifetime

The VLOOKUP function,
measured & explained.

How VLOOKUP works

Interactive lookup playground

The real-world error library

Where VLOOKUP works

Unlock the full VLOOKUP course

Frequently asked

How VLOOKUP works

Interactive lookup playground

The real-world error library

Where VLOOKUP works

Unlock the full VLOOKUP course

Frequently asked

Related functions