Finding common symbols in 2 spreadsheets

[Dick-Y]

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
of House.

Thanks for helping me, and saving me a lot of time.

Dick

[zeddy]

Hi Dick

Make sure you have both workbooks open.
Then, in workbook [House], in cell [H1] put the following formula:
=IF(ISNA(MATCH(A1,[Fish.xlsx]Sheet1!$B:$B,FALSE)),"","yes")
..now copy this formula down column [H] to row 1029 (or however many entries you have).

After copying the formulas down, you can 'convert' them to values by copying the block of formulas and using edit-pastespecial-values.

zeddy