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