Hello...I am using Excel 2007. I can't get beyond the following: =ISNUMBER(SEARCH("campaign",A2))=TRUE
This is what I'm trying to do...If cell A2 contains the word campaign, then return the complete entry for cell A2 (whatever is in cell A2); otherwise, enter "Employee Referral". Of course, the above format formula merely returns the word "True". So I tried to manipulate it by doing the following:
=ISNUMBER(SEARCH("campaign",A2)), "Employee Referral", and it really didn't like that. I don't know how to ask this question.