The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
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

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.