I need a formula that will tell me for each row that has a value of "1" in column A - do the values in column B match? (i.e. For all numbers that say "1" column B should say expired for all of those, however in this example there is 1 line item that does not match, it says "not expired". Technically, they should all match but they do not - I need to easily know the line items that have ones that don't match. Number 4 in column A is perfect because column b matches for both those line items.