When your comparison values are in a row across the top of a data table, use HLOOKUP to look down a specified number of rows. When your comparison values are in a column to the left of the data you wish to find, use VLOOKUP. HLOOKUP’s H stands for “Horizontal.”