Abbasi

Hello everybody

Sometimes, I have to struggle with my data a lot. Currently I am trying to extract data from a number of selective columns of the source sheet into a target sheet.

VLOOKUP function helps me retrieve data from a single column only. I intend to retrive data from more than one column, based on the same Lookup Value, in one go.

I will apprciate any help - doing it programmatically or using just a formula.

Craiglowdon

im unsure of what you mean, if you want the cells in the same cell then you can do

VLOOKUP(lookupValue,DataArray,column,0) & " " & VLOOKUP(lookupValue,DataArray,column2,0) & " "

and so on changing the column as you go, if you want them in separate cells them just change the column value on the lookup formula which is the third variable in the formula. (shown in bold)

hope i understood correctly and that helps.

Abbasi

Thanks for the response, Craiglowdon.

I want to retrieve data from different source columns into corresponding columns, separately, in the destination sheet.

Further help will be appreciated.

Colin Legg

Then put each of the suggested formulas into separate cells instead of concatenating them.

Also see response you got here:
http://www.mrexcel.com/forum/showthread.php?t=315823

If you need further help then please explain your question more clearly.