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

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 Kings@discussions.microsoft.com> wrote in message
news:FA9CD232-8D93-4E65-8889-74F2E449A1BB@microsoft.com...
>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 Kings@discussions.microsoft.com> wrote in message
> news:FA9CD232-8D93-4E65-8889-74F2E449A1BB@microsoft.com...
> >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 Kings@discussions.microsoft.com> wrote in message
> > news:FA9CD232-8D93-4E65-8889-74F2E449A1BB@microsoft.com...
> > >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
> >
> >