Vlookup in excell, how do I look up a match for 2 columns at once

[Suzie]

I cannot match 2 columns simultaneously in Vlookup...is that possible...if so
pls send a sample formula

 

[Franz Verga]

I cannot match 2 columns simultaneously in Vlookup...is that
possible...if so pls send a sample formula

Hi Suzie,

You have to use two different Vlookup formulas. Try to describe what is your
problem, maybe we can try to give a different solution. If you like you
could upload an example file to www.rapidshare.de or to www.savefile.com or
any other file sharing site...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Susan Carrier]

The way I solve this problem is by creating a "key" on each sheet by using
the CONCATENATE function. For instance, combine an item number and color code
with =CONCATENATE(A2,B2) on each sheet and then use the "key" on each sheet
as your link for your VLOOKUP

Susan Carrier