Technical Support

Join 2 lists in Excel using xlCompare

Spreadsheet Tools welcomes your inquiries. You can contact us by e-mail support@SpreadsheetTools.com, or fill the Technical Request form on the Spreadsheet Tools website.

We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare here.

We've created a F.A.Q section on our website. It contains answers to the most common questions we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic

Join 2 lists using xlCompare

Let review the typical situation: you have 2 lists of database values, and you need to merge them into single list which contains values from both lists.

xlCompare has a command which merges lists of values. To use it you need to compare 2 lists of data you have. Put them on 2 different worksheets and compare.

On this image we've highlighted command which joins 2 compared lists:

Command which joins to lists in Excel

This command is applicable to single pair of compared worksheets only. It is visible on the toolbar if you've selected a node under "sheet" node. In this example - old - new.

It joins two lists with database values and puts results into the left sheet. If you need to create a merged list on the another worksheet - you can repeat the operation after switching left and right panes.