table/dropdown calculation HELP PLZ

  • Thread starter Thread starter ridash
  • Start date Start date
R

ridash

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
 
=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)
 
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 Insert>Name>Define 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))
 
Back
Top