Searching for a text value (cell match) within text in multiple cells on another tab.

I hope this is an easy question for someone out there....

I have generated a function as below, that I can make work correctly when it only interrogates a single cell.

=IF(SUM(IFERROR(FIND(B3,'Tab2'!$H$4),0))>0,"FOUND","NO")

when I expand it to use a cell range (like below), it stops working.

=IF(SUM(IFERROR(FIND(B3,'Tab2'!$H$4:$K$625),0))>0, "FOUND", "NO")

What am I doing wrong?

Hoping there is a Guru out there who can advise.

How about?

=IF(COUNTIF('Tab2'!$H$4:$K$625,"*"&B3&"*")>0, "FOUND", "NO")

Thank you so much NBVC, that works perfectly !! :roll: