Quote:
Originally Posted by Spencer101
What do you want the result to be if the value in A6 IS found in one of the columns?
What about if it appears in more than one of the columns?
|
If a value is returned it can be left blank.
If a value appears more than once it doesn't matter. The idea of this formula is to check for the existence of a physical item in one or more locations where the item could move between locations. Therefore, if an item exists, it will appear on one of the lists. If it does not appear on the list then it means that it no longer exists and I need to be notified.