Find an entire string in a cell

[samitnair]

Hello Everyone

I need a formula to find if the cell value in in AH2 (Windows Servers/Network Connectivity and File Sharing) contains a sting "Network Connectivity and File Sharing" or not.

I have created a name range (HVLC) in another sheet with a list of wild cards like below

Network Connectivity and File Sharing
Network Connectivity and Instruments
Network Connectivity and Folders

The formula which I use is =IF(OR(COUNTIF(AH2,"*"&HVLC&"*")), "Yes", "")

if I hard code the above wild card values to the formula I am getting the output but when I use a name range I am getting #Spill

 

[Fluff]

How about
=IF(AGGREGATE(14,6,SEARCH(HVLC,AH2),1)>0,"yes","")