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!