Wauvel

Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All functions

HLOOKUP

Lookups & references

The horizontal lookup — find a value in the top row and return one below it.

Difficulty

Amateur
Excel file

1What is it?

HLOOKUP searches across the first row of a table for a value and returns a cell from a row below, in the same column. It's VLOOKUP turned on its side — handy when your data runs left to right, like periods across the top. It shares VLOOKUP's weaknesses: the row number is hard-coded and it only looks downward, so always end with FALSE for an exact match.

2What it looks like

HLOOKUP(lookup, table_array, row_index_num, [range_lookup])
lookup
The value to find — must sit in the first row of the table.
table_array
The table to search; the lookup row has to be the top one.
row_index_num
Which row to return, counted from the top (1 = first).
[range_lookup]
FALSE for an exact match (almost always); TRUE assumes a sorted row.

3When you use it

  • Pull a figure from a table with periods (months/quarters) across the top.
  • Map a column header to the value in the row beneath it.
  • Look up against a horizontal rate or tier table.

4See it in action

Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.

The periods run across the top row, so HLOOKUP searches row 1 and returns the Revenue row beneath.

E2
fx
=HLOOKUP("Q2", A1:D2, 2, FALSE)$135k
ABCDE
1MetricQ1Q2Q3Result
2Revenue$120k$135k$150k$135k

The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.

5Common errors

#N/ANo exact match — or FALSE was left off.

Fix: Add FALSE, TRIM stray spaces, and confirm the key sits in the top row.

#REF!row_index_num is taller than the table.

Fix: Count rows from the top of table_array, not from the sheet.

Breaks on insertA row was inserted, shifting the count.

Fix: Switch to XLOOKUP or INDEX/MATCH, which don't hard-code a position.

6Better functions & alternatives

  • XLOOKUP — Looks any direction, exact by default, with a not-found value. Prefer it when available.
  • INDEX + MATCH — Looks up a row or column and survives inserted rows/columns.

Want HLOOKUP already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.

Learn the moves here — or let Wauvel run them on your numbers.

Get my free report →