Using Excel 2007, on my d:/desktop, I have 2 speadsheets. One called "Fish" has 461 entries in col. B.
The 2nd one, called "House" has 1029 entries in col. A.
I want to find the entries that are common to both spreadsheets, and put "yes" for the matches in col. H
Thanks for helping me, and saving me a lot of time.