=IF(X14="Electrical",VLOOKUP(AF14,Costs!$A$2:$D$301,4,FALSE),IF(X14="Mechanical",VLOOKUP(AF14,Costs!$A$2:$D$301,4,FALSE),IF(X14="ICA",VLOOKUP(AF14,Costs!$A$2:$D$301,4,FALSE),IF(X14="Operational",VLOOKUP(AF14,Costs!$A$2:$D$301,4,FALSE),IF(X14="FLL",VLOOKUP(AF14,Costs!$A$2:$D$301,4,FALSE),IF(X14="Contract",VLOOKUP(AF14,Costs!$A$2:$D$301,4,FALSE),""))))))
Solved by Z. Y. in 15 mins