As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-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

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.

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

Posts

  • 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:

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

    That should work.

    tsmvengy on
    steam_sig.png
Sign In or Register to comment.