Microsoft Excel Hints and Tips

How do I perform a lookup based on the values in two columns ?

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.

Back to Questions Index

Return to Excel Exchange homepage.