Can someone help me to guide me how to use a formula to find a text within another formula?
example:
A1 ='[2013-01 CFT Exec Summary_EXCO.xlsx]Conso YTD'!$Z$9
I want cell B1 to validate A1 has updated or contained the file link to "2013-01 CFT Exec Summary_EXCO.xlsx" by returning a true/false statement.
Appreciated!!
Bookmarks