vlookup - Matching two cells?

[jumuraa]

Is it possible to do the following?

Worksheet1!A2 holds a text value
Worksheet1!B2 holds a text value

Worksheet2!D2 holds a text value
Worksheet2!C2 holds a text value

Is it possible to use vlookup to find a match for Worksheet1!B2 in Worksheet2!C2 where the combination of Worksheet1!A2, Worksheet1!B2 is the same as the combination of Worksheet2!D2, Worksheet2!C2?

 

[FKoenig]

Do you work for FROG?

 

[jumuraa]

@ buxtongt: That would probably work. I'll let you know if I can get it to.


@ FKoeing: I have been known to work with FROG. How do you know of them? Are you an RPCV?

 

[jumuraa]

@ buxtongt: After a little playing I think I've got it. It means a little more work if someone needs to update the master list, but it works!

 

[buxtongt]

Cheers! Glad it worked out for you.