Home › Learn Excel › Lesson 9
Combine INDEX and MATCH for lookups to the left, and build references from text with INDIRECT.
MATCH finds the row of a value, and INDEX returns what's in that row of another column. Together they look up anything. Find the department of Dina in F2INDIRECT turns text like B4 into a real cell reference. Change the text and the formula follows. Show the value of the cell whose address is in D2, in E2MATCH finds the row of a value, and INDEX returns what's in that row of another column. Together they look up anything. Find the department of Dina in F2