Vlookup with Multiple Columns to Match

[pt_lily]

I need to do a Vlookup that matches two columns on each worksheet instead of
just one. I have a Division Number column (B) and a Customer Number column
(C) in Sheet 1 and Division Number column (A) and a Customer Number column
(B) in Sheet 2 (GM Data). I need for both of these to match on each sheet
and then pull the matching data. I cannot just pull from the Customer
Number, because there might be the same customer number in different
divisions. The formula I have right now is =VLOOKUP(C8,'GM
Data'!B8:C270,2,FALSE) and I am getting a #VALUE! back. Is there a way to do
this?

Thank you!

 

[Sheeloo]

To do lookup on values in two columns I insert a dummy column C (assuming I
want to combine columns A & B, and the value to be found based on value in C
is in D) then use the following;

VLOOKUP(H1&K1,C,2,false)

 

[Pete_UK]

I'm not sure why you are getting #VALUE from your VLOOKUP - you would
normally expect this error when you try to do some arithmetic with
text values, unless you have that error within your data table.

Pete