| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search if a string contains text matching items in a list
I have a list of product codes on a sheet in column A and a ranges of cells
containing text that has the product code in amongst the text. I want to extract from that text the text that matches any product in the array in column A. I have tried using the find function as an array formula but it will only work if it finds the text of the first cell in the range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup or find matching number in text string | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| Matching items in 2 list to consolidate to one list | Excel Discussion (Misc queries) | |||
| Display top 5 items from a list with matching criteria? | Excel Discussion (Misc queries) | |||
| Matching Items from 1 list to 2 others | Excel Discussion (Misc queries) | |||
Threaded Mode
