Match Cell, compare adjacent values, return non matches

I have 2 spreadsheets. I am trying to come up with a formula that looks for a sku match, once it find the matching sku, it then looks to see if the column "discontinued" is different for that sku, if so, display the result.

Table Old Database Snapshot:

skuID    sku    Discontinued 
00001    ASZ1   TRUE
00002    HSED1  FALSE
00003    SESG   TRUE

Table Most Recent Snapshot:

skuID    sku    Discontinued    Formula 
00001    ASZ1   FALSE           TRUE        
00002    HSED1  FALSE
00003    SESG   TRUE

I have a formula that does something similar, it looks for new sku's or sku's that have changed, but I can't figure out how to do this for this specific scenario.

Here are the different formulas I've been working with: If I can incorporate it into this one, it will make the rest of the code a lot easier:


I've also tried to rebuild the formula to simply how this works, which I have half built, I'm just trying to figure out how to now do a check on the "discontinued" part of the formula. Doesn't matter if its R1C1 or A1 as I will convert it once it goes into VBA.


1 answer

  • answered 2018-03-13 20:40 Charles

    Vlookup with an if statement worked in this case.

    "If when you look it up and get a match returns true, show nothing, if different display from result from Old Database Snapshot."