I am looking for a function that will look for a value in a cell with several
values and if that particular value is present then put an asterix in the
corresponding cell in the next column. example:
I have a list of names in column A, in cloumn B i have a list of each
person's 4 favorite sports ( so if I have Bob in A1 then in B1, I have
Footabll (Alt+ enter) Baseball (Alt + Enter) Basketball (Alt+enter) golf(Alt
+enter)), in column C i want to return an "*" only if B contains "Golf"
I attemped =IF(ISERROR(SEARCH("Golf",B1)),"*","") ... but it retunred * even
for the ones that do not contain "Golf".
Can anyone please help?!?
Bookmarks