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.