Ho to get multiple column values in one shot thru vlookup

[Annalina]

Hi Friends,

How r u ?

My problem is how do i get multiple column values at one shot.
For example in one excel sheet i have columns A,B,C,D,E and in A column i have all the Partner ID's and rest of the columns i have the data.

Now in other excel file I have Partner ID's which are not in order...now i want the data in all 5 columns according to partner id's from the previous sheet i need to do a vlookup function for five times to get the same data....is there any way that we can do it in one shot.
Pls help me out.....

Thanks a lot in advance.
Hava fun filed day.

 

[Stormseed]

I love you.

 

[Stormseed]

Hi again Krishna

LOL !! I can't seem to understand a part of the formula. Have referred to the Excel Help file but in vain

Please help me understand this part of the formula:

 LOOKUP(9.999999999E+307,CHOOSE({1,2,3},0

a massive thanks to you for all the help you have given to me.

 

[Krishnakumar]

CHOOSE stores the result values in an array. Something like..

1. CHOOSE({1,2,3},0,#N/A,9896098960)

2. CHOOSE({1,2,3},0,#N/A,#N/A)

3. CHOOSE({1,2,3},0,9896098960,#N/A)

4. CHOOSE({1,2,3},0,9896098960,9896098900)

and the results..

1. =LOOKUP(9.99999999E+307,{0,#N/A,9896098960}) = 9896098960

2. =LOOKUP(9.99999999E+307,{0,#N/A,#N/A}) = 0

3. =LOOKUP(9.99999999E+307,{0,9896098960,#N/A}) = 9896098960

4. =LOOKUP(9.99999999E+307,{0,9896098960,9896098900}) = 9896098900

HTH

 

[Stormseed]

Ok...I am getting near to this...

The formula is looking up either of 2 match values in a particular worksheet and hence you are storing these values in an array, correct?

If yes, I need to retrieve a particular value from another worksheet on which either of the 2 values match with the one of the values in the main worksheet.

In Detail:

Worksheet A & Worksheet B

I have 2 seperate column values in A. I have the list of values ready in B. I want to retrieve one different field value from A to B only if one of the two values in A match with a particular value in B. To add, B has the list of only unique values to itself....in other words, no duplicates.

The above formula when implemented does not work to return the value I need from Worksheet A. I did the Custom format too as you had mentioned but in vain. Moreover, I played and tweaked your formula to different alternatives but failed to accomplish my need. Also, I am stumped about using If(iserror()) in this formula....errrr...now this can be implemented if the actual formula works !!

thanks again, my friend.

I find myself amongst the most noble people in this world who are members of this board. I ain't flattering guys...ask me...I have experienced it many a times !