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:
=IFERROR(IF(INDEX(Old!C2,MATCH(RC[5],Old!C1,0))<>RC[4],INDEX(Old!C2,MATCH(RC[5],Old!C1,0)),""""),""SkuNew"")
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.
=INDEX($A:$A,MATCH(A2,Old!$A:$A,0))
1 answer

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."
=IF(VLOOKUP(A2,Old!A:C,4,FALSE)=C2,"",Old!C2)