| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Entire Workbook | Excel Discussion (Misc queries) | |||
| Search within workbook | New Users to Excel | |||
| help with search | Excel Worksheet Functions | |||
| Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
Linear Mode
