×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Students Click Here

Control box with index

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.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close