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

can some please help me out


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

table/dropdown calculation HELP PLZ
 

=INDEX(A1:H8,MATCH(M1,A1:A8,0),MATCH(M2,A1:H1,0))* 13

where the table is A1:H8, and M1 and M2 are the 2 dropdowns


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ridash" wrote in
message ...

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

can some please help me out


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

table/dropdown calculation HELP PLZ
 

Hi Ridash

First create some named ranges. I named the complete range of your table
as Table, the whole of the top line of the table as Type and the whole
of the first column as Category using InsertNameDefine and pointing to
the relevant range of cells in each case.

With the inputs from your dropdown selections in A1, A2 and A3 in cell
A4 enter
=A3*INDEX(Table,MATCH(A1,Category,0),MATCH(A2,Type ,0))


--
Regards

Roger Govier


"ridash" wrote in
message ...

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

can some please help me out


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