there's no need to array-enter this:

=IF(SUMPRODUCT(--(ControlCentre!$C$77:$C$1000=Purchases!BM25)),
"Updated","Not updated")





In article ,
"Pat" wrote:

The following formula will return TRUE or FALSE. How do I modify it to
return a custom message like:

"Updated" for true
"Not updated" for false

{=SUMPRODUCT(1*(ControlCentre!$C$77:$C$1000=Purcha ses!BM25))0}

Much appreciate any help.

Pat