Formulas

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"))))))
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 3
maximum nested IFs 6
combine three if functions 3
copy cell color but not conditional format equations 2
The code below worked for a few days and just totally stoppedworking. What can I do to make sure it 1
Formula Help 2
v look up 2
VBA Worksheet Event Change or Selection Question, please assist me 2

Top