| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for first instance of text & return the value
This is a two part question...
Here's what I have: I have a list of product numbers in col. A. In col. O I have a list of file names that contain the product numbers as well as additional characters. I need a formula that will search col O for the first instance of the text in cell A2 and return that value. The next formula will return all instances that contain the text found in A2. Please help, I have a deadline of this evening for this and I've been wracking my brain and discussion Groups for this. Thanks so much!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to search for a text value with IF | Excel Worksheet Functions | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
| Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions | |||
| search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions | |||
Threaded Mode
