software

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 30then use something like

=IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,Sheet2!A1:B3,2,0))
--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Four Kingsquot; lt;Four gt; wrote in message
...
gt;I need to allow my users to select a text string from a drop downlist box.
gt; However each of the three possible text strings in the drop down box
gt; equates
gt; to a value that I need to use for calculations. How can I assign
gt; numerical
gt; values to the text selections?
gt;
gt; Could anyone tell me how to go about this?
gt;
gt; Thanks, BillThank you, I'll give it a try!

quot;Peo Sjoblomquot; wrote:

gt; Use a VLOOKUP table, if A1 is the cell with the dropdown, in another sheet
gt; you can have a table in A1:B3 built like
gt;
gt; string1 10
gt; string2 20
gt; string3 30
gt;
gt;
gt; then use something like
gt;
gt; =IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,Sheet2!A1:B3,2,0))
gt;
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Four Kingsquot; lt;Four gt; wrote in message
gt; ...
gt; gt;I need to allow my users to select a text string from a drop downlist box.
gt; gt; However each of the three possible text strings in the drop down box
gt; gt; equates
gt; gt; to a value that I need to use for calculations. How can I assign
gt; gt; numerical
gt; gt; values to the text selections?
gt; gt;
gt; gt; Could anyone tell me how to go about this?
gt; gt;
gt; gt; Thanks, Bill
gt;
gt;

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!
quot;Four Kingsquot; wrote:

gt; Thank you, I'll give it a try!
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; Use a VLOOKUP table, if A1 is the cell with the dropdown, in another sheet
gt; gt; you can have a table in A1:B3 built like
gt; gt;
gt; gt; string1 10
gt; gt; string2 20
gt; gt; string3 30
gt; gt;
gt; gt;
gt; gt; then use something like
gt; gt;
gt; gt; =IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,Sheet2!A1:B3,2,0))
gt; gt;
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; Portland, Oregon
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Four Kingsquot; lt;Four gt; wrote in message
gt; gt; ...
gt; gt; gt;I need to allow my users to select a text string from a drop downlist box.
gt; gt; gt; However each of the three possible text strings in the drop down box
gt; gt; gt; equates
gt; gt; gt; to a value that I need to use for calculations. How can I assign
gt; gt; gt; numerical
gt; gt; gt; values to the text selections?
gt; gt; gt;
gt; gt; gt; Could anyone tell me how to go about this?
gt; gt; gt;
gt; gt; gt; Thanks, Bill
gt; gt;
gt; gt;