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!
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.