Can anyone help with my problem?
 

I have a problem, I have two drop down boxes both with three values in
(The values are stored on a separate worksheet). I want to multiply an
independant value by a value determined by what is in the drop down
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 I
need them to be equivalent to different numbers e.g. value one in drop
down 1 is 2.5, how can I get them to be classed as numbers in the
formula whilst appearing as words and what formula would I need?


--
ExcelGuy
------------------------------------------------------------------------
ExcelGuy's Profile: http://www.excelforum.com/member.php...o&userid=24324
View this thread: http://www.excelforum.com/showthread...hreadid=379282

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 a
in A1: "One", in B1: "Two", in C1: 2
then D1 will return: 2 x 2.5 x 10 = 50
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ExcelGuy" wrote in
message ...

I have a problem, I have two drop down boxes both with three values in
(The values are stored on a separate worksheet). I want to multiply an
independant value by a value determined by what is in the drop down
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 I
need them to be equivalent to different numbers e.g. value one in drop
down 1 is 2.5, how can I get them to be classed as numbers in the
formula whilst appearing as words and what formula would I need?


--
ExcelGuy
------------------------------------------------------------------------
ExcelGuy's Profile:
http://www.excelforum.com/member.php...o&userid=24324
View this thread: http://www.excelforum.com/showthread...hreadid=379282

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
"ExcelGuy" wrote:


I have a problem, I have two drop down boxes both with three values in
(The values are stored on a separate worksheet). I want to multiply an
independant value by a value determined by what is in the drop down
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 I
need them to be equivalent to different numbers e.g. value one in drop
down 1 is 2.5, how can I get them to be classed as numbers in the
formula whilst appearing as words and what formula would I need?


--
ExcelGuy
------------------------------------------------------------------------
ExcelGuy's Profile: http://www.excelforum.com/member.php...o&userid=24324
View this thread: http://www.excelforum.com/showthread...hreadid=379282

Thanks alot guys you were a real help :)

ExcelGuy ;)


--
ExcelGuy
------------------------------------------------------------------------
ExcelGuy's Profile: http://www.excelforum.com/member.php...o&userid=24324
View this thread: http://www.excelforum.com/showthread...hreadid=379282

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"ExcelGuy" wrote in
message ...

Thanks alot guys you were a real help :)

ExcelGuy ;)