ExcelBanter - Search for data using 'contains'

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Search for data using 'contains' (https://www.excelbanter.com/excel-discussion-misc-queries/54723-search-data-using-contains.html)

JaB

Search for data using 'contains'

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

Search for data using 'contains'

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.

All times are GMT +1. The time now is 07:30 PM.