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