Lookup to return results from list based on symbol

Hello Excel Wizards,

I'm trying to find a method in which I can utilize a lookup formula or vba (if needed). The goal is to return results of "Yes" or "No" from a list, but the lookup is based on symbols within the second column. My hope is to find any URL that has the checkmark symbol to return a value of "yes" or "no". I tried using a If-vlookup combination formula and a regular lookup but continued to get errors especially since there are blank spaces and other "notes" in the cell. I enclosed a sample of this problem. Any help would be appreciated

Thanks for your time!

Or try:

=IF(IFERROR(UNICODE(VLOOKUP(P2,$A$2:$B$202,2,FALSE)),"")=10004,"YES","NO")

Not sure, put this on Q2 then copied down:

=IF(ISTEXT(INDEX($B$2:$B$202,MATCH(P2,$A$2:$A$202,0))),"Yes","No")

Thanks to all of you who took the time to look at that problem! Really appreciate it! For this particular problem I found that ChemistB and Phuocam solutions worked perfectly for this issue, but in an odd twist azumi and protonLeah solution's worked for another problem a fellow co-worker was having. Thanks again for all the help ya'll provided!