Match 2 worksheets

[vicstone]

How do I match 2 worksheets of exactly the same format? Both worksheets have columns A thru I. The match should be on cells A (3-digits), B (4-digits) & F (date YYYYMMDD for example 20101027). I need to produce result of every row in Spreadsheet 1 that does not have a corresponding row in spreadsheet 2. Then I need to produce a result of every row in Spreadsheet 2 that does not have a corresponding row in Spreadsheet 1.
What is the best solution to find mismatches?
Thank you.

[DonkeyOte]

Add a concatenation key to both Sheets - concatenating A, B & F - eg: =A1&"@"&B1&"@"&F1
(use of delimiter between each value to avoid false positive matches)

For each row on both sheets - simply search for the concatenated value on that row against all those listed on the other sheet (use MATCH)

Use the MATCH results to allow you to generate a listing of the missing entries on either sheet (use Auto Filter for ex.) - result will be #N/A where no match is found.

[vicstone]

Thank you. I do understand the concatenation part. However, I don't know how to use MATCH. Is this a command or something from pull down menu or some formula?
Thank you.

[DonkeyOte]

MATCH is a function.

Assume the concatenation column is Column Z on both Sheet1 and Sheet2.

Assume further that you wish for the results of the MATCH to be stored in Column AA on either Sheet

Please Login or Register  to view this content.

and conversely

Please Login or Register  to view this content.

Use Column AA on each sheet to identify those entries present on one sheet but missing on the other.