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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot match 2 columns simultaneously in Vlookup...is that possible...if so
pls send a sample formula
 
Suzie said:
I cannot match 2 columns simultaneously in Vlookup...is that
possible...if so pls send a sample formula
Click to expand...


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
 
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
 
Back
Top