The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns. HLOOKUP works exactly in the same way except that it looks horizontally rather than vertically. “V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal.