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