×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Control box with index

## Control box with index

(OP)
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

### RE: Control box with index

(OP)
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))

### RE: Control box with index

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)

)

### RE: Control box with index

(OP)
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.

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!