Excel question - matching data

Madpanda

I have 2 worksheets, both sheets have a column "customer id", some ID's are on both sheets, some are only on 1. What I need to do is basically

IF a customerid exists in both sheets, THEN look at column G of both rows and compare the data, IF it is different either throw a true or a number or something, which i could then use conditional formatting on.

So for example

Sheet1
Customer Id Column G
12345 Apples
49304 Bananas
20291 Pokemon



Sheet2
Customer Id Column G
12345 Apples
49304 Orangutans
99999 Whatever


49304 Orangutans This row would return a number or true or whatever as the value in column G differs from that of the same customerid in Sheet1.

I have tried a few things using vlookup or lookup (whichever returns the position), but it didn't fly.

tsmvengy

Use Vlookup to combine the two so you end up like this
Customer ID Column G Column H
12345 Apples Apples

Then in column I do something like =IF(G1=H1,"","FLAGGED")

You could even combine the two:

=IF(G1=VLOOKUP(A1,Sheet1table,column,FALSE),"","Flagged")

That should work.