Hi mona

it sounds like you need to use the VLOOKUP function in the cell to the right
of your drop down.

to do this you'll need a table somewhere else in the workbook which has the
values in the dropdown box and the ID's listed
e.g. Sheet 2
..........A..............B
1...Product......ID
2...Product 1....ID.1

etc
then in your vlookup formula use
=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0)
which means look up the value in A1 (ie the cell reference of the drop down
box) in the list in sheet 2 and when you find an exact match, return the
information from the second column of this table

Note, if you don't have a value in the cell that you're looking you'll get a
#NA error to overcome this use
=IF(ISNA(VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0)),"",VL OOKUP(A1,Sheet2!$A$1:$B$100,2,0))

Cheers
JulieD

"mona" wrote in message
...
Hello,,
how r u all,, i have a small prob. i hope u can help me with
i've created a drop down list in excel in one coloumn (the entire
coloumn's
cells contains the same list). .. the next coloumn should show the ID of
the
chosen data from the list. ID's r unique for each entery,, there are about
47
raws
how can i do that?