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

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

Thank you, I'll give it a try!

"Peo Sjoblom" wrote:

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

if you use a combobox from the forms toolbar your choice is automatically
assigned a value 1,2,or 3 in the linked cell
paul
remove nospam for email addy!



"Four Kings" wrote:

Thank you, I'll give it a try!

"Peo Sjoblom" wrote:

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