Indicate different cells in two worksheets

**MaxWol** · 10-10-2011, 06:15 AM

Hi all,

I've been struggling with this question for hours now.

I have two worksheets in one workbook.
An example of both can be found below.

How can I create my desired outcome as described in the last part?

Sheet 1 “offDB” : (contains the official database, total: 73.619 rows)

ID Model Name Manufacturer
100100 G410 Mitsubishi
100200 A53 Siemens
100300 TBD (AAB-1880030-BV) Sony Ericsson
100400 RM-669 Nokia
100500 M930 NA DB Motorola
100600 EBX700 Panasonic
100700 Tester Sony Electronics
100800 TCD718 Philips
etc.

Sheet2 “ourDB” :
(contains our own database, total: 41.470 rows)
(please note that some rows that can be found in sheet1 are missing in this sheet.)

ID Model Name Manufacturer
100100 G410 Mitsubishi
100200 A53 Siemans
100400 TRM-669 Nokia
100500 M930 NA DB Motorola
100600
100800 TCD718 Philips
etc.

Desired outcome:Sheet2:

\1

Any help is greatly appreciated!

**brokenbiscuits** · 10-10-2011, 06:26 AM

It would be helpful if you could elaborate further on the desired outcome, what you're actually trying to achieve.

For instance, what exactly do the correct/FALSE statements represent?

**MaxWol** · 10-10-2011, 07:04 AM

Thank you very much for your reply.

I am trying to insert TABS or pictures in my original post to make things clearer, but unfortunately this seems to be impossible.

The correct/FALSE statements represent whether the data in the 2nd and 3rd column of sheet 2 are exactly equal to the data in the corresponding row in sheet 1.

For example:

In sheet 2, row #3 contains the following information:
ID: 100400
Model Name: RM-699
Manufacturer: Nokia

In sheet 1, the corresponding row is #4, as it contains exactly the same ID
However the Model Name appears to different; TRM-699 instead of RM-699
ID: 100400
Model Name: TRM-699
Manufacturer: Nokia

What I want to do is to add 2 more columns to sheet 2, one concerning the Model Name to be correct or False, and the other concerning the Manufacturer to be correct or False.

So in this case it should state in sheet 2 in the 4th column that the Model Name is not exactly equal for the ID's in the two sheets. Therefore it should mention: FALSE

The 5th column should state: "correct". as the name of the manufacturer appears to be exactly equal in both sheets for the same ID.

**brokenbiscuits** · 10-10-2011, 07:29 AM

Something along the lines of the following in Sheet2 D2 and E2:

=if(vlookup($A2,offDB!$A:$C,2,false)=vlookup($A2,ourDB!$A:$C,2,false),"correct","FALSE")
and
=if(vlookup($A2,offDB!$A:$C,3,false)=vlookup($A2,ourDB!$A:$C,3,false),"correct","FALSE")

should work?

Also, in future, to post a sample workbook (infinitely better than an image), click the 'go advanced' button under the textbox, then click the paperclip to attach files.