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