I know this was possible in Lotus 1-2-3, but can't find a similar function
in Excel.

There is none. The only way this would be possible is to use VBA code. I
can't help you with that.

Biff

"StevanT" wrote in message
...
Biff,

Thanks for the quick response. Not exactly what I was after. What I
wanted
to do is (using your example), select an item in cell E2, and then return
the
required ID Number into E2, not into F2.
I know this was possible in Lotus 1-2-3, but can't find a similar function
in Excel.
I appreciate your help.

"T. Valko" wrote:

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?