JaB-

=IF(COUNTIF(B1,"*"&A1&"*"),"found","not found")

HTH
Jason
Atlanta, GA

"JaB" wrote:

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.