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