I need to compare text from one worksheet to another with a notification if there is a match
K Kesqsay Nov 17, 2005 #1 I need to compare text from one worksheet to another with a notification if there is a match
I Ian Nov 17, 2005 #2 =ISNA(MATCH(A1,Sheet2!A1:A10,0)) Assuming your text to compare is in A1 and the data to compare with is in A1:A10 on Sheet2. This will return TRUE if there is no match and FALSE if there is.
=ISNA(MATCH(A1,Sheet2!A1:A10,0)) Assuming your text to compare is in A1 and the data to compare with is in A1:A10 on Sheet2. This will return TRUE if there is no match and FALSE if there is.
