I have 2 sheets that I need to make sure the exact data is on both sheets.
For example, I have the data:

Sheet1
Date Salesman Product Units
12-Nov Joe Pen 10
15-Nov Pam Pencil 5
18-Nov Joe Pencil 16
20-Nov Doug Paper 5
21-Nov Pam Paper 10

Sheet2
Date Salesman Product Color Units
15-Nov Pam Pencil Black 5
20-Nov Doug Paper White 5
12-Nov Joe Pen Red 10
21-Nov Pam Paper off white 10


And what I want to make sure is that Nov. 20th, Doug, and paper is on both
sheets (Date, Salesman, & Product). The formula can be in one column and
return a yes, or 1 or 0. It doesn't matter, I just need to verify that it is
in their. Obviously my spreadsheet is more complex then above, but I will
basically be comparing name, date, and product.

Thanks in advance!

Can it be done?

If not on different sheets, what if it was on the same sheet?

"Lee" wrote:

I have 2 sheets that I need to make sure the exact data is on both sheets.
For example, I have the data:

Sheet1
Date Salesman Product Units
12-Nov Joe Pen 10
15-Nov Pam Pencil 5
18-Nov Joe Pencil 16
20-Nov Doug Paper 5
21-Nov Pam Paper 10

Sheet2
Date Salesman Product Color Units
15-Nov Pam Pencil Black 5
20-Nov Doug Paper White 5
12-Nov Joe Pen Red 10
21-Nov Pam Paper off white 10


And what I want to make sure is that Nov. 20th, Doug, and paper is on both
sheets (Date, Salesman, & Product). The formula can be in one column and
return a yes, or 1 or 0. It doesn't matter, I just need to verify that it is
in their. Obviously my spreadsheet is more complex then above, but I will
basically be comparing name, date, and product.

Thanks in advance!