Hey guys,

I would like to compare cell A1 and B1 to see whether they either match or they are false.

Therefore, =IF(A1=B1, "Match"). But if A1 doesn't equal B1 I would like A3: A9 to be marked as false as well.

I'm sure this is possible, just a heads up cells A3: A9 will already have existing formulas in them. Therefore, I'm hoping for something that will replace these.

Thanks, guys.