Microsoft Excel Hints and Tips
Question
How do I perform a lookup based on the values in two columns ?
Solution
Take a look at the extract below. Suppose you want to enter an individuals first
name and last name and then have a formula in cell B3 that performs a lookup and
returns that persons salary. Type
=INDEX(C7:C12,MATCH(B1&B2,A7:A12&B7:B12,FALSE)) into cell B3. Now click
on cell B3 and then press Ctrl + Shift + Enter to turn this
into an Array Formula.
Return to Excel Exchange homepage.