Hi,
take a look to CPearson web, go to the middle of the page where it says
Extracting Elements from one list not on another list

"Francisco Rodriguez" wrote:

Hello:

I got a consolidated list of items, "C", which is the latest update of items
I need to analyze. In the past I had received two previous lists "A" and B"
that I analyzed already but are now contained within list "C", along with new
items I have yet to analyze.

I want to be able to check from list "C" the items contained on either list
"A" or "B" or neither, and return a specific string depending on the outcome,
so that I know exactly which items I have left to analyze.

I tried an IF statement performing a VLOOKUP function along with ERROR.TYPE
against lists "A" and "B", to identify the items that are not on either list
"A" or "B". However, if the item IS on either one I get another error "#N/A"
that just does not look elegant. This is happening because if the VLOOKUP
finds the item on "A" or "B", then the ERROR.TYPE returns "#N/A" and the IF
statement can't be evaluated, hence it returns #N/A.

Is there a way to get specific strings both when an item is and when it
isn't on lists "A" or "B", without returning "#N/A"?

I appreciate your support. Thanks in advance.

Sincerely,