Check if column contains specific values in excel

Question

I need to check in excel whether a column (b1:b300) contains only 2 specific values 1,-24. How can check this using formulas only. Please help

Answer 1

You can use a VLOOKUP, and depending if you search for ANY of the two or BOTH of the two, you combine two VLOOKUP as needed.

=VLOOKUP(arg,range,1,FALSE) will yield #N/A if not found, which can be further analyzed using the =ISNA() function

Answer 2

It is simple:

=COUNTIFS(B1:B300,"<>1",B1:B300,"<>-24")