Have a look in Help under VLOOKUP
Come back with questions if you need help after reviewing the way this
function performs.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bobby Mir" wrote in message
...
hi there,

i'm looking to find out if anyone can help with a certain task i've been
trying to accomplish. what i have in an excel sheet is a list of reference
codes to different items set up as a drop down list. what i'm trying to do
now is, whenever i select an item in the drop down list, i want a
different
cell on the sheet to change in value, number value that is. does anyone
have
any suggestions on how i could go about this? the drop down list is pretty
long...i'd say atleast 50 or so items.

example:
i choose reference code "2B5-2312" from the drop down list, and then i
want
cell B1 to change to whatever the value of that code is...so in this case
its a numeric value of 12.

again, choosing reference code "TXL-3451" should give a numeric value of
24
in cell B1.

hope this helps explain what i'm trying to do! any help would be
appreciated.

thanks,
bobby