LinkBack URL
About LinkBacks
I think the formula you want for C1 is =IF(SUMPRODUCT(--(NOT(ISERROR(SEARCH(B1,A1:A3))))),"Football") changed to B2 and "Soccer" for C2.
I think the formula you want for C1 is =IF(SUMPRODUCT(--(NOT(ISERROR(SEARCH(B1,A1:A3))))),"Football") changed to B2 and "Soccer" for C2.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks