+ Reply to Thread
Results 1 to 2 of 2

Matching two sheets

  1. #1
    Riyad
    Guest

    Matching two sheets

    How can I compare two sheets of data? One being a master list and the other
    is a small list. Both have prices and product numbers column and other
    information, what I want to do is to run the small sheet through the master
    sheet of data. Then, create a new sheet of the matched rows of both sheets
    side by side to do a price analysis, and etc.

    Your help is greatly appreciated.



  2. #2
    Miguel Zapico
    Guest

    RE: Matching two sheets

    One of the ways of doing it may be the following:
    - Identify the column that contains unique codes that can be compared in
    both sheets (let's say it is column A in both cases)
    - Add in the small sheet as many columns as you need, with formulas like:
    =VLOOKUP(A1,Sheet1!$A$1:$Z$500,2,FALSE)
    that has to be adjusted to your particular case in terms of range and column
    retrieved (see the help on the function for more details)
    - This will give you values for the matched codes, and errors for the
    non-matched ones. Now sort or filter the data on any column that have some
    errors on it, and copy the rows with no errors in them to a new sheet, where
    you can run your analysis.

    Hope this helps,
    Miguel.

    "Riyad" wrote:

    > How can I compare two sheets of data? One being a master list and the other
    > is a small list. Both have prices and product numbers column and other
    > information, what I want to do is to run the small sheet through the master
    > sheet of data. Then, create a new sheet of the matched rows of both sheets
    > side by side to do a price analysis, and etc.
    >
    > Your help is greatly appreciated.
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1