| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Search one cell for same data in another cell
I need a formula that can search a string of text in one cell for the data that is returned in another cell.
Example: A2: 9/26/2010 follow up B2: NAME C2: Today() "9/26/2010" D2: C2 formated to read today's date as DD "26" Cells C2 and D2 will update daily as the dates change. I need E2 to search anywhere in A2 for the value in D2 and return the value in B2 if true. Any help would be greatly appreciated!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use cell data for a web search & bring back in the results? | Excel Worksheet Functions | |||
| Search for data and return cell reference | Excel Worksheet Functions | |||
| I need to search for then extract a specific portion of cell data... | Excel Worksheet Functions | |||
| when I search for data in Excel, the found cell cannot be seen | Excel Discussion (Misc queries) | |||
| how do I search for any cell containing data and apply conditiona. | Excel Discussion (Misc queries) | |||
Threaded Mode
