Hi All,

I need to assign a numeric value to a text string, so when the end use
selects a particular text from a dropdown list it returns a numeri
value to be used in a formula. Tried everything I know, need help
please

--
Message posted from http://www.ExcelForum.com

Select some out of the way cells and assign RangeNames to them that are the
same at the TEXT selections in your dropdown list. Then type the numbers in
each box you wish each of them to represent.

Then a formula like =A1+RangeName would use the RangeName in the
formula, but return the number in the result.

hth
Vaya con Dios,
Chuck, CABGx3




"skyriakidis >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I need to assign a numeric value to a text string, so when the end user
> selects a particular text from a dropdown list it returns a numeric
> value to be used in a formula. Tried everything I know, need help,
> please.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Hi

if you set up a table on another sheet with your text string and the numeric
equivalent, you can use the vlookup function to return the associated
value - either to a cell or directly into the formula

say your drop down list is in sheet 1 A1 and the table is in sheet 2 A1:B100
and you want the numeric value returned to sheet 1 B1, in sheet 1 B1 type
=IF(A1="","",VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0))

or if you want the put the numeric in a formula in B1 you can do something
similar to this
=IF(A1="","",VLOOKUP(A1,Sheet2!A1:B3,2,0)*1.1)

or whatever the formula is

hope this helps
Cheers
JulieD

"skyriakidis >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All,
>
> I need to assign a numeric value to a text string, so when the end user
> selects a particular text from a dropdown list it returns a numeric
> value to be used in a formula. Tried everything I know, need help,
> please.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>