Search for text string in different column return true or false

I have been looking on forums and using Google searches for the better part of a day now and cannot seem to get this working. I have gotten close, but not quite what I need. What I need to do is compare a cell containing text with against a column that contains text on a different sheet.

For example in cell A1 I have text "hostname"

In another sheet I have a column of hostnames in format of "hostname.domain.com" or a variety of text tacked on to the text from A1. So I really need the formula to look for my text string anywhere in the text of the cell range.

I want the cell with the formula to give a true/false if the text in A1 is found in that other column. The search needs to be case insensitive.

The closest I got after trying to use MATCH, SEARCH, FIND was:

=VLookup(A1,'Sheet1'!$G$3:$G$3779,1,False)

But that is for an exact match which does not work as it isn't exact and doesn't really return true/false.

Any help would truly be appreciated. Thank you.

Worked like a champ! Thank you for the help.