How to inlcude another variable into the logical test of the IF function

Hi

In my formula below you can see that I start my IF function with <> (not equal to) "GOPHER", but I want that now to also include <> "MOVING MINDS" How do I include them both in that logical test?

=IFERROR(IF(M3<>"GOPHER","No",IF(Y3="NULL",VLOOKUP(VALUE(G3),'Top 100'!A:H,8,FALSE),VLOOKUP(VALUE(Y3),'Top 100'!A:H,8,FALSE))),"No")

Try it like this:

IFERROR(IF(AND(M3<>"GOPHER",M3<>"MOVING MINDS"),"No",IF(Y3="NULL",VLOOKUP(VALUE(G3),'Top 100'!A:H,8,FALSE),VLOOKUP(VALUE(Y3),'Top 100'!A:H,8,FALSE))),"No")

(Changes in red).

Hope this helps.

Pete

That worked great, thank you!

Glad to hear it - thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete