Asigning a numeric value to text.

S

skyriakidis

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
 
C

CLR

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
 
J

JulieD

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
 
Top