How to use search function with if function
<p>My excel sheet have bank name, IFSC code and account number.</p>

<p>I want to get bank name from IFSC Code. For this I've used the following formula:</p>

<pre><code>=IF(SEARCH("DNB",P17),"DELHI NAGRIK SEHKARI BANK",IF(SEARCH("SBIN",P17),"STATE BANK OF INDIA",IF(SEARCH("PUNB",P17),"PUNJAB NATIONAL BANK",IF(SEARCH("CNRB",P17),"CANARA BANK","TYPE BANK NAME")))).
</code></pre>

<p>It works for first option only (here, formula shows 'Delhi Nagrik Bank') and for other option it shows <code>#Value</code>.</p>

<p>Please tell me my mistake.?</p>