Vlookup - Add entries to sheet that didnt match
I have 2 spreadsheets. Source data spreadsheet and Exisiting data spreadsheet. I do a Vlookup in existing data spreadhseet to get values from source data spreadsheet. There may be new entries in Source data spreadhseet that do not exisit in Existing data spreadsheet. I want to get those entries into my existing data spreadsheet. How do I do that?
|