samedi 24 décembre 2016

How to use search function with if function

Sir, my excel sheet have bank name, ifs code and account number. I want to get bank name from IFS Code. For this I've used formula =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")))). It works for first option (here, formula shows 'Delhi Nagrik Bank') only and for other option it shows '#value'. Please tell me my mistake.

Aucun commentaire:

Enregistrer un commentaire