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. It puts a list of things to do in the "actions" column cell, each list different, based on what is picked from pulldown "items" column cell.
But now, 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. Either an x or an o will go in the cells based on what is picked in pulldown. The "action" names will now be in the title row.
How would I do that?
Bookmarks