Look across: HLOOKUP

Some tables run sideways: the labels are in the first row. HLOOKUP(what, table, row number, FALSE) finds a column by its first row and returns a value from that column.

4 exercises in this lesson are part of ExcelHero Pro.