<div>
Hi Sandra,<br />
<br />
Try below:<br />

<pre><code id="code-20-42119942-1">=IF((COUNTIFS($N$3:$N$10,&quot;*+SHRA*&quot;)&gt;0),5,IF((COUNTIFS($N$3:$N$10,&quot;*-SHRA*&quot;)&gt;0),3,IF((COUNTIFS($N$3:$N$10,&quot;*SHRA*&quot;)&gt;0),4,0)))</code></pre>
</div>


Hi Sandra,

Try below:


=IF((COUNTIFS($N$3:$N$10,"*+SHRA*")>0),5,IF((COUNTIFS($N$3:$N$10,"*-SHRA*")>0),3,IF((COUNTIFS($N$3:$N$10,"*SHRA*")>0),4,0)))

<div>
Thanks, it works perfectly.
</div>


<div>
Glad it did !<br />
gowflow
</div>


<div>
<div class="content wysiwyg-content">
I have a sheet that uses the index function to return data based on some criteria. &nbsp;What I am needing is a formula that will search on a sheet in cells N3:N10 for +SHRA, if found, then the resulted value would be a 5, if SHRA is found, then the value would be a 4, if -SHRA is found then it would be a 3, if nothing is found then it would be a 0. &nbsp;The tricky part is I could have multiple of those values. &nbsp;So I need to search for +SHRA first, then if not found then search for SHRA, if not found, then -SHRA.
</div>
</div>


I have a sheet that uses the index function to return data based on some criteria.  What I am needing is a formula that will search on a sheet in cells N3:N10 for +SHRA, if found, then the resulted value would be a 5, if SHRA is found, then the value would be a 4, if -SHRA is found then it would be a 3, if nothing is found then it would be a 0.  The tricky part is I could have multiple of those values.  So I need to search for +SHRA first, then if not found then search for SHRA, if not found, then -SHRA.

Finding Certain Criteria

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.