Functions
HLOOKUP
Searches first row of range, returns value from index row
Try it
When to use it
When should I use HLOOKUP instead of VLOOKUP?
Use HLOOKUP when your data is laid out in rows, so the lookup runs across the top row and pulls a value from a row below. Use VLOOKUP when the data is in columns.
Why does my HLOOKUP return the wrong column?
Usually because the last argument defaults to approximate match. Pass FALSE as the fourth argument to force an exact match unless your top row is sorted and you want the nearest value.
Use cases
Find a quarter's revenue from a row header
=HLOOKUP("Q2", {"Q1", "Q2", "Q3"; 100, 250, 175}, 2, FALSE)Map a tier to its discount across a row
Used in
retail · sales · operations
Syntax
HLOOKUP(search_key, range, index, [is_sorted])Examples
=HLOOKUP("b",{"a","b","c";1,2,3},2,FALSE) // => 2
=HLOOKUP("a",{"a","b","c";10,20,30},2,FALSE) // => 10
=HLOOKUP("c",{"a","b","c";10,20,30},2,FALSE) // => 30