VLOOKUP & IF Conditions Together ?

hi to all experts,

here I want a formula in cell C7 according to Table1, Table2, Table3, Table4 & table 5. which is if C7
is equal to Dia 75 than take data from Table 2 i.e. 0.112 through VLOOKUP & same thing I want with condition IF.

i tried to make something but i failed in this regard i attached a sheet for your kind reference.

thanks & regards,,,,


Irfan Khan

thanks for reply,

@ Ace_XL : as per your reply i applied formula which is = =VLOOKUP(D7,IF(C7=50,$O$7:$P$9,IF(C7=75,$O$14:$P$17,IF(C7=110,$O$22:$P$33,IF(C7=160,$O$38:$P$49,IF(C7=200,$O$54:$P$63))))),2,FALSE)
& also checked my table & converted all of them to text to numbers.

After applying your formula : it is just picking the values from Table 2.
Pls tell me alternate or try to execute this formula yourself in attached excel sheet.


waiting for your response....

Irfan Khan

thanks Ace_XL .....


Regards,,,,,