# Get instant live expert help on if false excel

“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(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
Trying to get true false if 2nd & 3rd row has data, row 1 is false =IF(AND(RC[-8]>1,((RC[1]),(RC[10])>1)),FALSE, TRUE)
Solved by G. E. in 18 mins
=IF(ISERROR(VLOOKUP(B9,\$M\$2:\$M\$10000, 1, FALSE)),FALSE,TRUE )
Solved by A. H. in 14 mins
=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(B16="Destroy",VLOOKUP(B14,ReturnTable,2,FALSE),IF(B16="Return to Mfg",VLOOKUP(B14,ReturnTable,3,FALSE),IF(B16="Repack",VLOOKUP(B14,ReturnTable,4,FALSE),IF(B16="Restock",VLOOKUP(B14,ReturnTable,5,FALSE),"None")))) This is the formula I am truing to work with, but it keep returning an error.
Solved by Z. W. in 27 mins