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

=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