View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
StevanT StevanT is offline
external usenet poster
 
Posts: 2
Default Select an item from dropdown list but return value from adjacent c

What I would like to do is have an array of data in columns, the first column
being the Item, the second being the ID Number, etc. In a cell, I would like
to see a list of Items from which I can select, but once selected, I want to
return the ID Number into the cell. Is this possible?