I need to know how to compare a single cell to a range of cells. Here's what I want to do.
I have values in cells A1-A169. I want to compare the value in cell B1 to those values in A1-A169. If the value in cell B1 is equal to any value in A1-A156, then return "ok", otherwise "not okay."
I am doing this for B1, B2, B3, etc...
Here's what I did:
This isn't working though. It doesn't appear to be comparing the range. It only returns "Ok" if the value for say B1 is also in A1, even though I want it to compare the range. I'm betting it's painfully obvious, but what do I need to change?
Thanks in advance.