Control box with index

[jgreg43]

I have a control box where I will select a type of pipe, then in another cell I have placed the size of pipe i will use. In this last cell where i want to place the results from a friction loss formula by using the control box to find the inside pipe dia. of the pipe type and pipe size I have selected, then perform a formula to provide a friction loss result to be used in another cell. Below I have attached the formula in the cell which I am trying to place the friction loss results:

cell B9 is control box
cell E8 is pipe size
cells S4 to W14 is the range. row T4-W4 has type of pipe.
column S4-S14 has pipe sizes to use.
cell I8 is where I need to place the friction loss per foot.
formula in cell I8 is as follows:

=(4.52*D9^1.85)/(P2^1.85*(INDEX(MATCH(B9,S5:W14,TRUE),MATCH(E8,T4:W14,TRUE)))^4.87)

D9 is gpm being used in calc. which is 13
P2 is C factor being used which is 120

How do i pull in the right cell to use in the formula to multiply by P2^1.85*(?)^4.87

 

[jgreg43]

Here is my latest improvement on the above formula, but when I change combo box in cell B9 my results do not change with it. I know I need to add it in somewhere into the formula below but not sure where.

=(4.52*D9^1.85)/(P2^1.85*(INDEX($S$4:$W$14,MATCH(U17,$S$4:$S$14,),MATCH(T17,$S$4:$W$4,))^4.87))

 

[SacreBleu]

Try:

=(4.52*D9^1.85)/(P2^1.85*(INDEX($S$4:$W$14,MATCH(U17,$S$4:$S$1,0),MATCH(T17,$S$4:$W$4,0))^4.87)

)

 

[jgreg43]

Here is what I finished up with.
=(4.52*D9^1.85)/(P2^1.85*(INDEX($S$4:$W$14,MATCH(E8,$S$4:$S$14,),MATCH(B9,$S$4:$W$4,))^4.87)) and it works.
Thanks for the input.