Hi,
I'm looking for an IF formula with reference to another worksheet and two ranges:
The two ranges are supposed to be identical. When they aren't I want an IF formula in another worksheet to display an Attention.
But the formula does not respond upon different values in the two ranges L4:L13 and P4:P13. The cell remains blank.
RAM
I'm looking for an IF formula with reference to another worksheet and two ranges:
Code:
={IF('Income Verification'!L4:L13<>'Income Verification'!P4:P13,"Attention Income Verification","")}
The two ranges are supposed to be identical. When they aren't I want an IF formula in another worksheet to display an Attention.
But the formula does not respond upon different values in the two ranges L4:L13 and P4:P13. The cell remains blank.
RAM