nested if statement using different tab vlookups

you cant(well you can but its not right) use whole column,or ranges in if or as the lookup value
consider
=IF(L:L=1,"x","y") that will work but it only looks at the row the formula is in
so if its in row 1 it looks at l1
if its in row 100 it looks at l100

Typically, you'd use a single cell as the reference like this:

=IF(L1=VLOOKUP(L1,.....

However, looking at your formula I'm guessing there's a better way to do what you want.

Can you explain what you want the formula to do?

OK, you have to test each cell in column L individually.

Assuming your first cell is L2, try this:

=IF(COUNT(MATCH(L2,MISSY!F:F,0),MATCH(L2,WOMEN!F:F,0),MATCH(L2,PETITE!F:F,0)),"X","")

Copy down as needed.

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.