Comparison Help

[redsunrising15]

Hey all,

I am trying to use the following logic:

Read text from Sheet2 B1.
If the text is identical to anything from Sheet 3 A1:A16, skip next step:
( Read text from Sheet2 A1.
If Sheet2 A1 matches anything in Sheet1 A1:A500, skip next step:
{Print: Sheet2 A1 is not present!}
)
And repeat for all of Sheet 2 values of B and A.

Thanks in advance for your help!

 

[sgroath]

try this in cell C1 of Sheet2:
=IFERROR(IF(MATCH(Sheet2!B1,Sheet3!A$1:A$16,0)>0,""),IFERROR(IF(MATCH(Sheet2!A1,Sheet1!A$1:A$500,0)>0,""),"Sheet2 A"&ROW()&" is not present!"))

copy down to remaining cells in column C