ExcelBanter - Search one cell for same data in another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Search one cell for same data in another cell (https://www.excelbanter.com/excel-worksheet-functions/266082-search-one-cell-same-data-another-cell.html)

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!!

Quote:

Originally Posted by dtime (Post 959736)

Have you tried using a PIVOT TABLE for this?

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)))