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?
|