VLookup 2 columns?

  • Thread starter Thread starter Wynn
  • Start date Start date
W

Wynn

I'm using VLOOKUP to yield data where A2 occurs in $J$2000.

Is there are way to use VLOOKUP to check if A2 and B2 next
to each other occur in J2:$J$2000 and K2:$K$2000 next to
each other?
 
Yes, with concatenation............first concatenate your columns J and K
into column I and use it as the lookup column for the following in C2, (and
copy it down column C as needed).....

=VLOOKUP((A2&B2),LookupTable,4,FALSE)

Vaya con Dios,
Chuck, CABGx3
 
Hi
one way (returns column L): enter the following array formula (entered
with CTRL+sHIFT+ENTER)
=INDEX(L2:L2000,MATCH(A2&B2,J2:J2000&K2:K2000,0))
 
Back
Top