I have a spreedsheet (SH1) that I'd like to compare Column C against spreadsheet 2 (SH2) Column A. Whenever I find a match, I'd like to update column L of SH2 with the contents of column K of SH1. When I don't find a match, I'd like to add the contents of Column C from SH1, as a new entry to Column A in SH2. Can this be done easily? I've been trying to write macros with no luck at all. Thx