2 Column VLOOKUP search

[Guest]

Can VLOOKUP be used to search and match 2 columns except
just one?

 

[Frank Kabel]

Hi
one way:
- create a helper column in your lookup range
- concatenate both columns (e.g. =B1 & C1)
- copy this formula down

use this helper column to compare your lookup value

 

[Dave Peterson]

Another way:

=INDEX($L1:$L999,MATCH(W1&CHAR(1)&X1,$A$1:$A$999&CHAR(1)&$B1:$B$999,0))

This matched W1&X1 with A1&B1 through A999&B999.
and returned the value in column L.

 

[Dave Peterson]

and forgot to add...

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)