I have a spreadsheet with a list of titles such as this one in A2
<colgroup><col></colgroup><tbody>
</tbody>
CLT Referrals May 2017 I have a formula working on that cell: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #006107}span.s2 {color: #ab30d6}span.s3 {color: #0057d6}</style>=IF(ISNUMBER(SEARCH(Referrals,A2)), "Yes", "No") the formula is returning no, when it should be returning yes. It returns no whether I have the word Referrals in A2 or not. Can you tell me what I'm doing wrong? If it makes a difference, I'm the Excel for Mac 2011. Thank you for any help you can give me! Wellen |
<colgroup><col></colgroup><tbody>
</tbody>