Excel 2007 : Compare two worksheets based on multiple columns

**infiltraitor** · 12-09-2010, 01:28 AM

Hello,
I was wondering if it was possible either via VB or formula to compare data against two worksheets on a separate worksheet based on unique data columns that are identical on both worksheets. I am particularly looking to see if it can be done if all of the columns match on both worksheets

For example:

1st worksheet - Raw Data
Column1 Column2 Column3 Column4 Column5 Column6
Dave Dave Don Darrell Jim 1236
Dan Dan Gina Bill Todd 3214
Brandon Brandon Sara Sara Alma 4789

2nd Worksheet - Raw Data
Column1 Column2 Column3 Column4 Column5 Column6
Dave Dave Don Darrell Jim 1236
Dan Dan Gina Eric Todd 3214
Scottie Brandon Sara Sara Alma 4789

3rd worksheet - Results
Column1 Column2 Column3 Column4 Column5 Column6 Column7
Dave Ray Don Darrell Jim 1236 TRUE
Dan Dan Gina Eric Todd 3214 FALSE
Scottie Brandon Sara Sara Alma 4789 FALSE

This would be on a greater scale and my thoughts are of using a VLookup or some formula using SumIf but not sure.

If someone has a suggestion that would be great. It would be cool do to this via VB but anything will help.

Thanks

**davesexcel** · 12-09-2010, 02:34 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!