Can I use VLOOKUP to find exceptions in a file and MATCH on those exceptions?
I have 2 tables:
- Source table - Data the is pulled in weekly (automated export)
- Destination Table - Takes Data from Source - using INDEX / MATCH data to find common ID NUMBERS between the tables.
To get the common ID NUMBERS to match, once the weekly export is added to the SOURCE file, I search and find the new ID NUMBERS in the Source table, then manually add the new ID NUMBER's to the Destination table.
This triggers the INDEX / MATCH formulas in all the columns of the Destination table to bring in the other data associated with that ID NUMBER from the Source table. (multiple columns get pulled in)
Instead of manually doing this , can I use a VLOOKUP reference to MATCH on exceptions?
In practice this would first look at ID NUMBERS in the DESTINATION Table and for those that ARE NOT A MATCH in the SOURCE TABLE, bring those new (unmatched ) ID numbers into my Destination sheet. Then as i update the Source sheet with new weekly data the VLOOKUP will find the new ID NUMBERS without me manually adding them to the Destination sheet.
Hope that made sense. Any ideas how to construct a formula using VLOOKUP or another formula method?