Use a VLOOKUP table, if A1 is the cell with the dropdown, in another sheet
you can have a table in A1:B3 built like

string1 10
string2 20
string3 30


then use something like

=IF(A1="","",VLOOKUP(A1,Sheet2!A1:B3,2,0))



--
Regards,

Peo Sjoblom

Portland, Oregon




"Four Kings" <Four wrote in message
...
I need to allow my users to select a text string from a drop downlist box.
However each of the three possible text strings in the drop down box
equates
to a value that I need to use for calculations. How can I assign
numerical
values to the text selections?

Could anyone tell me how to go about this?

Thanks, Bill