Can you make your MYLOOKUP table have the one key column and then 12 more
columns with a single word in each cell?
Then you could just use 12 of those =vlookup()'s to get your 12 different words:
=VLOOKUP(D471,MYLOOKUP,2,0)
=VLOOKUP(D471,MYLOOKUP,3,0)
=VLOOKUP(D471,MYLOOKUP,4,0)
=VLOOKUP(D471,MYLOOKUP,5,0)
....
=VLOOKUP(D471,MYLOOKUP,12,0)
=VLOOKUP(D471,MYLOOKUP,13,0)
Remember to may that MYLOOKUP table 13 columns wide.
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
--
Dave Peterson