Try this:

A2:A10 = items
B2:B10 = ID numbers

Create a drop down list of the items:

Select cell E2
Goto the menu DataValidation
Allow: List
Source: =A2:A10
OK

Enter this formula in cell F2:

=IF(E2="","",VLOOKUP(E2,A2:B10,2,0))

Biff

"StevanT" wrote in message
...
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?