INDEX and MATCH

MATCH finds the position of a value. INDEX returns the value at a position. Together they look up anything.

4 exercises in this lesson are part of ExcelHero Pro.