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!

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:D,2,false)

"pt_lily" wrote:

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!

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

On Aug 25, 5:32*pm, pt_lily wrote:
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!