AboutPricing

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.
< Go Back

    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