Matching two sheets

[Guest]

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.

 

[Guest]

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.