I have 2 files Test1 and Test 2 and would like to vlookup data from Test 2 into Test1 and if it is #N/A then add those records to the main file.
I am uploading test 1 and test 2 and what the final file should look like.
I've been trying this for a while and haven't been able to figure it out.
Thanks!
Bookmarks