Here is one I hope is easy have a workbook excel 2010, I have sheet 1 and sheet 2 both have column A and B with information in them actually all numbers. example : A 3451876 B 877-0151754

like 500 lines in each sheet.

I need to see if one number in column A from either sheet are actually on either sheet and if so i need it to tell me something yes no N/A or duplicate the number. Just so long as I can see if one number from either sheets column A is on the other sheet column A.