Can anyone help with my problem?

E

ExcelGuy

I have a problem, I have two drop down boxes both with three values i
(The values are stored on a separate worksheet). I want to multiply a
independant value by a value determined by what is in the drop dow
boxes.

E.g. Independant value*Value in drop down 1*Value in Drop down 2

However the values in the drop down boxes are words not numbers but
need them to be equivalent to different numbers e.g. value one in dro
down 1 is 2.5, how can I get them to be classed as numbers in th
formula whilst appearing as words and what formula would I need
 
M

Max

Assuming the DVs are in A1 and B1, and C1 contains the independent value,
think you could try something along this line in say, D1:

=C1*VLOOKUP(A1,{"One",2.5;"Two",5;"Three",7.5},2,0)*VLOOKUP(B1,{"One",5;"Two
",10;"Three",15},2,0)

If the DV selections / values are:
in A1: "One", in B1: "Two", in C1: 2
then D1 will return: 2 x 2.5 x 10 = 50
 
A

Anthony Slater

Put values in the column next to your source list.

A1='your word'
B1=2.5

etc

In the cell next to your first drop down list, put
=VLOOKUP(A1,sheet2!A1:B3,2,0)

That way, when your word is chosen from the drop down, the corresponding
value is displayed in the cell.

This number can then be used for your calculations.

HTH
T
 
Top