table/dropdown calculation HELP PLZ
 

hello everyone
i came to a dead end and i need help
i have this table


cl-air tl air cl sea cl A-sea cl B-sea truck LTC
Truck

CAT. A 0.43% 0.18% 0.43% 0.28% 0.18% 0.43% 0.18%
CAT. B 0.40% 0.18% 0.40% 0.28% 0.18% 0.40% 0.18%
CAT. C 0.45% 0.18% 0.45% 0.28% 0.18% 0.40% 0.18%
CAT. D 0.35% 0.18% 0.35% 0.28% 0.18% 0.35% 0.18%
CAT. E 0.60% 0.25% 0.60% 0.28% 0.18% 0.60% 0.18%
CAT. F 0.33% 0.18% 0.33% 0.25% 0.25% 0.33% 0.25%
CAT. G 0.90% 0.30% 0.90% 0.28% 0.18% 0.90% 0.18%


from drop down 1 person picks CAT.
and from drop down 2 person picks cl-sea.....ltc truck
and in a cell they put a number

what i want is when they pick from the dropdown menus the % should be
multiplies by the number inputed

for example

drop down 1 CAT. C
drop down 2 cl sea
this means 0.45%

inputed number lets say is 13

the equation then should be 0.45% * 13


if you want file is attached
can some please help me out


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4917 |
+-------------------------------------------------------------------+

--
ridash
------------------------------------------------------------------------
ridash's Profile: http://www.excelforum.com/member.php...o&userid=35617
View this thread: http://www.excelforum.com/showthread...hreadid=553954