The Data TextToColumns feature will split the 12 words into 12 columns, if
that's what you mean.......or, if you want to return 12 separate cells with
VLOOKUP, then you would need a separate VLOOKUP formula in each cell to
return that one value,....the difference being to increment the "2" in your
original formula to 3,4,5,....etc....

hth
Vaya con Dios,
Chuck, CABGx3



"roger_home" wrote:


Someone on this site gave me (a newbie) the following to fill in a cell
in a row if another cell in the same row has an item picked from a
pulldown I have. (The list for the pulldown is on another sheet).

=VLOOKUP(D471,MYLOOKUP,2,0)

It works fine, but now instead of filling the VLOOKUP items (12 words)
in the cell, I would like to have 12 separate items put into 12
separate cells in that same row, when an item is picked from the
pulldown.

How would I do that?


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=516529