Vanilla Forums has been nominated for a second time in the CMS Critic "Critic's Choice" awards, and we need your vote! Read more here, and then do the thing (please).
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

Excel question - matching data

MadpandaMadpanda Registered 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.

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

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.

    steam_sig.png
Sign In or Register to comment.