Home › Learn Excel › Lesson 8
Find a value in a table: VLOOKUP for columns, HLOOKUP for rows and XLOOKUP for everything.
HLOOKUP is VLOOKUP turned on its side: it looks along the top row and returns a value from a row below. Look up the sales for the month in A6, in B6XLOOKUP looks for a value in one column and returns the value from the same row in another column. Find the price of product P-104 in F2