| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching the formula (not the value) for a text string
Basically I'm trying to add some checks to a table the gets updated on a regular basis.
The formulas for three of the cells contain dates: =IFERROR(I14/ROUNDUP((("4/5/2014"-VLOOKUP($C$14,'Goals'!$A:$I,8,FALSE)) /(VLOOKUP($C$14,'Goals'!$A:$I,9,FALSE)-VLOOKUP($C$14,'Goals'!$A:$I,8,FALSE)))*VLOOKUP($C$ 14,'Goals'!$A:$I,2,FALSE),0),"") as part of the check I'd like to compare today() with the string of text in the formula that is the date to make sure they've been updated. I have a tab with all the validations and I've tried concatenating the formula cell with an ' to force it into a text value but that didn't work. Nor does trying to change it to a text value. Bahttext gave me some kind of hebrew text. Any other options? I'd like it to be a formula not a VBA solution. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching String for phrases/multiple text strings | Excel Worksheet Functions | |||
| Searching for a string of text inside a column | Excel Worksheet Functions | |||
| Formula for searching for a text string | Excel Discussion (Misc queries) | |||
| Searching a text string in a range of cells. | Excel Worksheet Functions | |||
| searching cells for a string of text | Excel Programming | |||
Threaded Mode
