Good morning

I have two columns of data which differ slightly, and would like to setup a
Lookup type of formula that will compare the two columns and return a value
when the data from column A is contained in column B.
Any ideas?

Thanks in advance.