Need Help with Formulas ?

[VICTOR5]

hi to all experts,

here I need a formula in the Cell E7 for example :

if C7 is equal to Dia 150 than take values as per table1 & if E7 is equal to
dia 200 than take value as per table 2 according to nos of Pipes i.e. Cell D7 .

waiting for response


thanks & regards,,,,,,

[benishiryo]

hi there, you probably got to change your title to something more meaningful. but here goes:
=IF(C7=150,VLOOKUP(D7,$N$7:$O$10,2,0),VLOOKUP(D7,$N$14:$O$17,2,0))

[Ace_XL]

Try..

=IFERROR(VLOOKUP(D7,IF(C7=150,$N$7:$O$10,IF(C7=200,$N$14:$O$17)),2,FALSE),"")

[VICTOR5]

lots of thanks Mr. benishiryo from bottom of heart coz the same thing i was searching.

regards....

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.