Formulas

  • Thread starter Thread starter Smooth75
  • Start date Start date
S

Smooth75

What is wrong with this formula? I get "#value" as the answer.

=IF(VLOOKUP(C10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(D10,$J$22:$K$53,2,FALSE="W"),IF(VLOOKUP(E10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(F10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(G10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(H10,$J$22:$K$53,2,FALSE)="W","Still In","OUT"))))))
 
Check your other post.
What is wrong with this formula? I get "#value" as the answer.

=IF(VLOOKUP(C10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(D10,$J$22:$K$53,2,FALSE="W"),IF(VLOOKUP(E10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(F10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(G10,$J$22:$K$53,2,FALSE)="W",IF(VLOOKUP(H10,$J$22:$K$53,2,FALSE)="W","Still In","OUT"))))))
Click to expand...
 
Back
Top