How to equate Text Drop Down selections to numerical values

G

Guest

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
 
P

Peo Sjoblom

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
 
G

Guest

Thank you, I'll give it a try!

Peo Sjoblom said:
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
Click to expand...
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign numerical value to cell based on selection from drop-down m 1
How do I give numerical values to each text item in a list 1
Using a Drop Down Menu 1
Associated Numerical Values 3
How to create 2 dependent drop down lists from 1 original drop dow 5
Linking numerical values to a text drop down box 1
Filtered drop down list 2
drop down list and adding numeric values to text 2

Top