I have 2 sheets with matching columns where the first column in each sheet contains a key. Sheet 2 contains some of the rows in sheet 1 with updated data. How can I replace the rows in sheet 1 with those in sheet 2 if there is a matching key.
Example Sheet 1
KEY | NAME | CITY |
---|---|---|
123 | Bob | Seattle |
124 | Steven | Chicago |
125 | Tom | San Diego |
Example Sheet 2
KEY | NAME | CITY |
---|---|---|
123 | Bob Doe | New York |
New Sheet 1
KEY | NAME | CITY |
---|---|---|
123 | Bob Doe | New York |
124 | Steven | Chicago |
125 | Tom | San Diego |
I'm not sure if this is something that can be done via VLOOKUP or if I should create a script for it.