How to equate Text Drop Down selections to numerical values
 

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

How to equate Text Drop Down selections to numerical values
 

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

How to equate Text Drop Down selections to numerical values
 

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

How to equate Text Drop Down selections to numerical values
 

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