Search for data using 'contains'

[JaB]

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.

[Jason Morin]

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.