As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread:

Excel question - matching data

MadpandaMadpanda suburbs west of chicagoRegistered User regular
edited June 2009 in Help / Advice Forum
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

Customer Id Column G
12345 Apples
49304 Bananas
20291 Pokemon

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.

Steam/PSN/XBL/Minecraft / LoL / - Benevicious | WoW - Duckwood - Rajhek
Madpanda on


  • tsmvengytsmvengy Registered User regular
    edited June 2009
    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:


    That should work.

    tsmvengy on
Sign In or Register to comment.