I think I'm making this way harder than it probably is. I need to search for certain text within a field. If it is found I want to apply a value when found.

For example.

Column A Is the column I'm searching
A1 - 123 Jason
A2 - New York
A3 - Atlantic Ocean

Column B Is the column I'm comparing against or searching for
B1 - Jason
B2 - York

Column C
C1 - Football (If Jason was found in the range A1:A3 the output would be Football)
C2 - Soccer (If York was found in the range A1:A3 the output would be Soccer)

As you can tell I want to search the entire column A. I also want to search using the entire (index/range, etc.) of Column B. It would not have to be case sensitive. Thanks for your help!