VLOOKUP vs HLOOKUP: Which One Fits Your Table

Excel & Google Sheets

How it works

The letters say it all: VLOOKUP searches Vertically down the first column of a table and returns from a column you count rightward; HLOOKUP searches Horizontally across the first row and returns from a row you count downward. They're the same function rotated 90 degrees — same exact-match FALSE argument, same counting logic, same #N/A on a miss. Since most real data is arranged vertically (one record per row), VLOOKUP covers the vast majority of lookups; HLOOKUP exists for the layouts where labels run across the top, like months in a budget or quarters in a forecast. If you're on Excel 2021/365 or Google Sheets, XLOOKUP replaces both — it doesn't care which direction the data runs — but the V/H pair still matters in older files.

E2

The value to find — searched down column A by VLOOKUP, across row 1 by HLOOKUP.

A2:C5

The table. VLOOKUP searches its first COLUMN; HLOOKUP searches its first ROW.

3

Count 3 columns rightward for VLOOKUP; in HLOOKUP the same number counts rows downward.

FALSE

Exact match — required in both, or unsorted data returns wrong values silently.

When to use it

VLOOKUP for the everyday case: price lists, employee rosters, order logs with one record per row. HLOOKUP for wide layouts — pulling February's number from a budget where months run across the top.

Common mistakes

• ✕Counting columns when HLOOKUP wants rows.

  ✓The third argument flips meaning: in =HLOOKUP("Feb",F1:H2,2,FALSE), the 2 means second ROW of the range, not second column. Count in the direction the lookup travels.

• ✕Leaving off FALSE in either function.

  ✓Both default to approximate match and silently return wrong values on unsorted data. Always close with FALSE: =VLOOKUP(E2,A2:C5,3,FALSE).

• ✕Fighting a wide layout with HLOOKUP everywhere.

  ✓If you're constantly HLOOKUP-ing a huge wide table, the layout is the problem — one record per row is easier to filter, sort, and total. Paste Special → Transpose flips it, then VLOOKUP takes over.