Essentially, I'm trying to merge info from one spreadsheet into another. The Destination sheet has some of the records (with matching unique IDs) form the Source, but not all. I'd like to check if the Unique ID exists in the Destination array, and if not, bring parts of the record from the Source to the Destination sheet. My first thought was to create a third sheet, where I'd test whether there's a match, and if not, display the cell there, but I ran into some circular referencing issues. Essentially, I'm updating one sheet (destination) with data/records from another (source) - I've figured out how to update records with matching IDs, thanks to the help of this forum, but am stuck bringing in those records who's IDs do not yet exist in the destinationVLOOKUP_Test_Book.xlsx
Thanks for any help!