“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=IF(VLOOKUP(A2,T$4:Y$30,3,FALSE)=" ",VLOOKUP(A1,T$4:Y$30,3,FALSE),VLOOKUP(A2,T$4:Y$30,3,FALSE))

Solved by S. H. in 20 mins

=IF(ISERROR(VLOOKUP(B9,$M$2:$M$10000, 1, FALSE)),FALSE,TRUE )

Solved by A. H. in 14 mins

=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

=IFERROR(VLOOKUP(B2,PROJ!$B$2:$I$192,8,FALSE),0)+IFERROR(VLOOKUP(C2,PROJ!$B$2:$I$192,8,FALSE),0)+IFERROR(VLOOKUP(D2,PROJ!$B$2:$I$192,8,FALSE),0)+IFERROR(VLOOKUP(E2,PROJ!$B$2:$I$192,8,FALSE),0)+IFERROR(VLOOKUP(F2,PROJ!$B$2:$I$192,8,FALSE),0)+IFERROR(VLOOKUP(G2,PROJ

Solved by S. Q. in 14 mins

I need a formual that makes a cell red if false. B5>.1 true B5>.1 false

Solved by I. J. in 21 mins