Hi All,
I am trying to create a lookup formula to either find the items which are NOT in a given list... or if it's a lot easier to simply say 'Yes', there are items existing which are not from your list.
Example
Let's say I have column A with 1000 rows. Almost every entry will be either 'Apple', 'Pear', or 'Peach' and that is what's expected. However, if there is a row that has something else like 'Banana' or 'Grape', I need to know. Note that this column of data is not sorted and can't be because it's already sorted by a different column.
So, in this example, I'd like the formula to return the unexpected entries(Preferred) or at least return "Unexpected entries found..."
Thanks for any help on this!
Bookmarks