Formula to compare inventory that is NOT in another inventory list

another option is to use your preferred lookup formula, (index/match, Match, vlookup), and just put it into an IFERRROR formula.

That way when one Is not found it brings back your choice of wording....

example: IFERROR(vlookup(A1,C:D,2,false),"NOT FOUND")

If you only want to bring back IF there is an error, you can use ISERROR inside an IF... Leaving the FALSE argument as an empty string.

Example: IF(ISERROR(Vlookup(A1,C:D,2,false)),"The item was not found","")

Jason

Hi 'Ranger,

This can be done in exactly the same manner as was done in your previous question.

In that case, the Countif function was used to count the number of occurrences in Central Inventory of each of the numbers in Existing Inventory.

My formula or SG's formula was placed in a new column in the Existing table, and did the counts of the same numbers on the Central table.

Barry: B2: IF(LEN(A2)<1,"",IF(COUNTIF(central inventory::A,A2)<1,A2,""))

SGIII:  B2: IF(COUNTIF(central inventory::A,A2)<1,A2,"")

For this question, My formula or SG's formula is placed in a new column in the Central table, and does the counts of the same numbers on the Existing table.

Barry: B2: IF(LEN(A2)<1,"",IF(COUNTIF(existingl inventory::A,A2)<1,A2,""))

SGIII:  B2: IF(COUNTIF(existing inventory::A,A2)<1,A2,"")

Results, in eah case will follow the same pattern as in the previous question.

Regards,

Barry