Question: how to create a hlookup formula in excel?
Answer: Summary. ... 
Look up a value in a table by matching on the first row.
The matched value from a table.
=HLOOKUP (value, table, row_index, [range_lookup])
value - The value to look up. ... 
HLOOKUP searches for a value in the first row of a table.