How To Do HLOOKUP In Excel?

Select the cell where you want the result

Type `=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])`

Replace `lookup_value` with the value you want to find

Replace `table_array` with the horizontal range containing the data

Replace `row_index_num` with the row number in the selected range to return the result from

Use `FALSE` for an exact match

Use `TRUE` for an approximate match

Press Enter

Example: `=HLOOKUP(A1, B1:F4, 3, FALSE)`