Vlookup with 2 columns

  • Thread starter Thread starter Gary H
  • Start date Start date
G

Gary H

Excel 2000

Is it possible to do a verticle looking comparing 2 columns rather than just
1? Thanks.

Gary
 
=INDEX(F1:F100,MATCH(C1&C2,D1:D100&E1:E100,0))

it is an array formula, so commit with Ctrl-Shift-Enter.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP isn't working properly in Excel on Mac 1
how do I change text direction in Excel doc 1
Auto Fill formula from a column to row 1
horizontal display vs Vertical 1
Some rules about Vlookup REPOSTED 6
vlookup with numbers 10
Convert text to number automatically 1
vlookup instructions,, or help making a formula 7

Back
Top