Vlookup with 2 columns

G

Gary H

Excel 2000

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

Gary
 
B

Bob Phillips

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

it is an array formula, so commit with Ctrl-Shift-Enter.
 
Top