What it does (in plain English):
HLOOKUP searches across the top row of a range to find a value, then returns a result from a row beneath it. Use it when your headers (codes, months, SKUs) run left→right.
Syntax: HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
- lookup_value: what you’re searching for (e.g., "P200").
- table_array: the block to search (top row must contain the keys).
- row_index_num: which row to return within that block (1 = top row).
- range_lookup: FALSE for exact match (recommended); TRUE (or omitted) for approximate.