Hello everyone
The formula below looks to see if the cell contains the word "Test" and also checks to see if another cell is not blank. If this conditions are true, then it should return a blank value, else it should return "Test Found", I just can't get the formula to return that. Not sure where I'm wrong.
![]()
IF(ISNUMBER(SEARCH(and("Test",E2,F2<>""),"","Test Found")))
Bookmarks