IF formula with reference to another worksheets array

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
Hi,

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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
=AND(EXACT('Income Verification'!L4:L13,'Income Verification'!P4:P13))+0

which is confirmed with control+shift+enter.

Custom format the formula cell as:

[=0]"Attention Income Verification";[=1]""
 

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
Thanks [again] Aladin,

That worked! How do I get this text to display in red font? I tried Conditional formatting; Formula Is, =Z65="Attention Income Verification".

RAM
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
RAM said:
Thanks [again] Aladin,

That worked! How do I get this text to display in red font? I tried Conditional formatting; Formula Is, =Z65="Attention Income Verification".

RAM

In CF, invoke:

Cell Value Is, Equal to, 0
 

Watch MrExcel Video

Forum statistics

Threads
1,118,169
Messages
5,570,638
Members
412,334
Latest member
ExcelForLifeDontHate
Top