Is there a way in excel to do some semi-automated pattern matching and add a new column as a result? Im sure I can use VLOOKUP for the pattern matching, but how do I create a macro to automate the entire process of opening a existing file, create a vlookup table and inserting the correct vlookup syntax as a new column? Here are some specifics:
I have two excel files. One contains only two columns and essentially never changes (Masterlist). The second file is a report that is generated daily with different bits of data. However there is one common element between the two files called "SiteID." For each daily report I would like to be able to match the SiteID to the Masterlist and add the second column from the Masterlist to the daily report. Example:
Here is what I have now...
Here is what I would like...
Bookmarks