ExcelBanter - Vlookup with 2 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup with 2 columns (https://www.excelbanter.com/excel-discussion-misc-queries/27920-vlookup-2-columns.html)

Gary H

Vlookup with 2 columns

Excel 2000

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

Gary

Bob Phillips

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

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

--
HTH

Bob Phillips

"Gary H" wrote in message
...
Excel 2000

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

Gary

All times are GMT +1. The time now is 04:03 AM.