All TalkersTech Sections

How To Match Data In Excel From 2 Worksheets

Last Updated : Mar 16, 2022

How To Match Data In Excel From 2 Worksheets

In this article we will show you how to match data in excel from 2 worksheets, Comparing two Excel sheet can be difficult for some people. But Excel make it easier for you if you know the process to compare the worksheet.

There are many different ways by which you can match data in 2 worksheet. In this article you will learn some easy and simple formulas which can make your work easier.

Before that you have to download "practical workbook". You can download practical workbook from Google.

Now we will start with 2 different method to match data from two different worksheet in Excel.

Step By Step Guide On How To Match Data In Excel From 2 Worksheets :-

Method 1 - Side by Side method ine different workbooks

Before we start let's just assume that we have two different workbook which is named book 1 and book 2. And both the books have same data which is starting from the same row in column B. Now virtually we will match the data slide by slide.

  1. At first open your “Book 1” workbook.
  2. Now click on view which is located on the the upper side of the Excel sheet.

    How To Match Data In Excel From 2 Worksheets

  3. After this click on the new window option.
  4. Then just select the view side-by-side option after it gets visible.

    How To Match Data In Excel From 2 Worksheets

  5. After selecting view side by side you will see option of synchronous scrolling under side by side, just select that option.

    How To Match Data In Excel From 2 Worksheets

  6. Then click on arrange all option. After this a dialogue box will appear.
  7. Then, select vertical option from the list.

    How To Match Data In Excel From 2 Worksheets

  8. And then press ok.

Once you press ok you will see two workbook are displayed side by side by which you will be able to compare data and find match easily there. This method is useful when you have less number of comparison of data virtually.

Method 2 - Side by Side method in similar workbook

In this method we will compare two different worksheet in similar workbook. As you can see there are 2 worksheet named sheet 1 and sheet 2 in the Excel workbook.

Here we will split the spreadsheet into two different workbook and then we will follow the same previous steps that we have use for previous method.

  1. At first go to the view ribbon.
  2. Now click on view which is given on the top of your Excel sheet.
  3. Then select window option you will get a drop down after clicking window.
  4. A drop down will appear and then click on new window.
  5. Once you click on new window you will see two different workbook displayed on your screen. These two workbook will have similar worksheet to compare data from sheet 1 to sheet 2. You can find the matches virtually.

    How To Match Data In Excel From 2 Worksheets

Conclusion :-

These were the two easy methods mention above can help you in doing the matching of two different worksheet. I hope this article on how to match data in excel from 2 worksheets helps you to match data in 2 worksheet easily.

LATEST ARTICLES