PDA

View Full Version : 2-D Vlookup?



blumfeld0
10-30-2007, 12:26 AM
Hello. I am trying to look up values contained in 2 columns and return the correponding values in a few other columns.
I hope the attached excel file helps to show what I have and what im trying to do
thank you!

Bob Phillips
10-30-2007, 12:37 AM
I am confused, it just looks like

=C1, = D1, =E1 to me from your layout.

anandbohra
10-30-2007, 02:20 AM
hi blumfeld0

pl see attached file u get your desired output
for 2D or 3D or n number of lookups first step is to join your values then run lookup
in attached file see column A u get what I mean to

shaqil
10-30-2007, 04:39 AM
use concatenate function before Vlookup then u wil get desired result.

blumfeld0
10-30-2007, 07:15 AM
thank you very much. I will try these suggestions and hopefully they will work for the data i have. thanks again!