# Get instant live expert help on false and false

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

=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