macro to compare data in column A of sheet 1 with data in column A of sheet 2

[nanda]

Hi Excel Experts,

Please provide me a macro which will compare data of column A in
sheet 1 with data of Column A in sheet 2 and display "FOUND" [ in
column B ] next to identical data.

thanks in advance,
nanda

 

[Guest]

=if(countif(Sheet2!A:A,A1)>0,"Found","")

in B1 of sheet1, then drag fill down the column. Repeat similar in sheet2.

No need for a macro.

 

[nanda]

=if(countif(Sheet2!A:A,A1)>0,"Found","")

in B1 of sheet1, then drag fill down the column. Repeat similar in sheet2.

No need for a macro.

--
Regards,
Tom Ogilvy

Hi Excel Experts,

Please provide me a macro which will compare data of column A in
sheet 1 with data of Column A in sheet 2 and display "FOUND" [ in
column B ] next to identical data.

thanks in advance,
nanda- Hide quoted text -

- Show quoted text -

Thanks so much, it solved my issue, I appreciate your time.

Nanda