Merge Sheets is a replacement for VLOOKUP and INDEX/MATCH functions. The add-on simplifies the task of combining data you have in two different tables. It scans and matches key columns in two sheets that you specify, and gets all the necessary updates into your main table. Set the tool to update only new and/or empty cells and pull non-matching rows from another spreadsheet.
Try it for 30 days for freeMerge Sheets is an indispensable tool for matching and merging records from two sheets. The add-on matches the records from the columns you select and updates your main table with the corresponding data from the lookup table.
Using the tool, you control what will be pulled:
You can always go with the VLOOKUP or INDEX/MATCH functions to combine two sheets. However, practice showed that these are difficult to understand, and we haven't even mentioned that they can be combined with other Google functions to make your lookup criteria more advanced and flexible.
Our tool offers 5 simple steps that will take about a minute of your time to adjust the settings.
Open Merge sheets from the Merge & Combine group in Power Tools and do the following:
See a more detailed description here.
Merge Sheets can color the changes for you. Once you choose the corresponding option on the last step, you'll be offered a palette with different hues — pick the one you like and enjoy the results.
If you don't like the colouring, make use of the status column. It will be inserted to the right of your table indicating the type of values: updated, new, matching, etc.
Feel free to use both options at the same time to your best convenient. :)
No worries, you'll be able to choose whether your tables have headers and what columns to update with the data.
For that, simply skip the step where you choose columns to update, and head straight for extra options — Add non-matching rows to the main table is the one you need.
That again depends on the options you select. :) Have Merge Sheets to fill only empty cells in your main table or don't pull those blanks from the lookup table.