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!
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!
I am confused, it just looks like
=C1, = D1, =E1 to me from your layout.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Always Mark your Thread as Solved the moment u got acceptable reply (located under Thread tools)
Practice this & save time of others in thinking for unsolved thread
use concatenate function before Vlookup then u wil get desired result.
thank you very much. I will try these suggestions and hopefully they will work for the data i have. thanks again!