I have a formula that looks like this:
=if(OR(B$1=2,B$1=5,B$1=33,B$1="b",B$1="m",B$1="z"),"Ok","Check Value").
In reality, however, instead of having only 6 reference values (2, 5, 33, b, m,and z), I actually have a hundred of these non-changing reference values and 1,000 data to check/compare.
Is there a way of collecting all of these reference values in one cell (for example, in A1) and have a simple formula reference A1 while satisfying the conditions? If not possible, is there any other simpler method than having using the OR function with 100 different reference values (I have not tried if this is possible or if there is a limit in OR functions).
Thanks in advance.
Bookmarks