Hi,
I've been trying to write a formula to return a yes or no if part of a cell contains a value stored in a separate cell (B1 in this case).
Ive tried =IF(ISNUMBER(SEARCH(d1,A2)),"Yes","No")
But obviously that will probably look for an entire match. Whereas I have data like this
A B 2014/09/01 2014/09/02 testing false 2014/09/01 testing true
Where data in column A has other data included. Any help you guys can offer would be v. much appreciated
Bookmarks