If you are using the drop down box from the forms toolbar you can use your
list as the range for =index(data_range,row number(cell link for drop down
box),Column number in range for the number say 25 related to your lookup
value say 2t5-234).
paul
remove nospam for email addy!



"Vasant Nanavati" wrote:

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.

And how is anyone supposed to figure this out? Is there an algorithm that
determines what value is assigned to what reference code?

--

Vasant