Originally Posted by
mandy02
Sorry that didn't work. I realize though that saying it is looking for a value is not exactly right. Here is what it is comparing:
192.168.16.1.........................192.168.16.1
192.168.16.2.........................192.168.16.2
192.168.16.3.........................192.168.16.3
192.168.16.4.........................192.168.16.4
192.168.16.7.........................192.168.16.5
192.168.16.8.........................192.168.16.6
192.168.16.10........................192.168.16.7
So, for example Column 1 is A1-A7. Column 2 is B1-B7. I want to know if B1 is equal any IP in cells A1-A7. If so then return OK. Right now I'm only getting OK for cells B1-B4 because those values are in the same column. I keep getting Not Oka for cells B5-B7 even though the values do exist in A1-A7.
Thanks again.
By my reckoning it's only B5 & B6 that don't exist in A:A, B7 occurs in A5.
Anyway here's the formula
HTH
Bookmarks