Return match result

  • Thread starter Thread starter gootroots
  • Start date Start date
G

gootroots

example:

book1 sheet1 contains non duplicate values in A1:A10

book2 sheet1 contains non duplicate values in A1:A10

I need a formula to reurn "record matched" or "record not matched" in book2
sheet1 in B1:B10

thank you if you can be of help!
 
The below formula in Book2 sheet1 cell B1 and copy down as required

'If book1 and book2 are unsaved open workbooks then
=IF(COUNTIF([Book1]Sheet1!$A$1:$A$10,A1),"Record matched",
"Record not matched")


'If book1 and book2 are saved open workbooks then
=IF(COUNTIF([Book1.xls]Sheet1!$A$1:$A$10,A1),"Record matched",
"Record not matched")


If this post helps click Yes
 
Back
Top