Question: how to do a hlookup?
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.