| 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!! |
|
#2
|
|||
|
|||
Quote:
Dates have serial numbers in excel and it may be difficult what has to be done in your question. Unless, in column E, every cell has =TEXT(A2,"DD") then F2 would have the formula: =IF(ISERROR(MATCH(D2,E:E,0)),"Not Found",INDEX(B:B,MATCH(D2,E:E,0)))
__________________
Asobi Wa Owari Da |
| Reply |
| 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) | |||
Linear Mode
