Tool 02 · Data lab

HLookup Online: Lookups Across Rows

HLOOKUP · XLOOKUP

For data that runs across rows, with labels in the first column.

100% in your browser: your data never leaves your device

matching keys on both sheets! = equal keys
Step 01

Your list

100% in-browser
Step 02

Lookup table

100% in-browser

Visual guide: how HLOOKUP finds the answer

looks across, then counts down

=HLOOKUP(lookup_value, table_array, row_index_num, FALSE)

Argument 01

lookup_value

The value you are looking for.

✎ Trim spaces first!

Argument 02

table_array

The whole table. The keys must be its first row.

✎ Lock it with $ ($B$1:$M$3)

Argument 03

row_index_num

Which row to return, counting from 1 at the key row.

✎ Insert a row and this number goes stale!

Argument 04

range_lookup

FALSE for an exact match.

✎ Leave it out and you get an approximate match!

Revision Q&A

(click a question) Lab module 02
Q1: What is the difference between HLOOKUP and VLOOKUP?

VLOOKUP searches down the first column of a table. HLOOKUP searches across the first row, for data laid out horizontally with labels in the first column.

Q2: Can XLOOKUP replace HLOOKUP?

Yes. XLOOKUP works in both directions: give it a row instead of a column and it searches across. The tool shows both formulas for your data.

Q3: Is my data uploaded anywhere?

No. Everything runs in your browser. Your data never leaves your device.

Know someone fighting with a spreadsheet? Send them this page.