Fernandez30
New Member
Hi,
Please help me creating a formula, what i need is if a cell A2 contains a word "BRA" then it should give me the result as "Celma" so on and so forth.
BRA  CELMA, GBR Caledonia, HUN  Hungary, USA  Lafayette, LHR  London, MYS Malaysia, TWN  Taiwan, Anything else  Others
I created a formula however it is not working
=IFERROR(IF(FIND("BRA",A2,1),"Celma",IF(FIND("GBR",A2,1),"Caledonia",IF(FIND("HUN",A2,1),"Hungary",IF(FIND("USA",A2,1),"Lafayette",IF(FIND("LHR",A2,1),"London",IF(FIND("MYS",A2,1),"Malaysia",IF(FIND("TWN",A2,1),"Taiwan"," "))))))),"Others")
Can somebody please help me.
Please help me creating a formula, what i need is if a cell A2 contains a word "BRA" then it should give me the result as "Celma" so on and so forth.
BRA  CELMA, GBR Caledonia, HUN  Hungary, USA  Lafayette, LHR  London, MYS Malaysia, TWN  Taiwan, Anything else  Others
I created a formula however it is not working
=IFERROR(IF(FIND("BRA",A2,1),"Celma",IF(FIND("GBR",A2,1),"Caledonia",IF(FIND("HUN",A2,1),"Hungary",IF(FIND("USA",A2,1),"Lafayette",IF(FIND("LHR",A2,1),"London",IF(FIND("MYS",A2,1),"Malaysia",IF(FIND("TWN",A2,1),"Taiwan"," "))))))),"Others")
Can somebody please help me.
Attachments

31 KB Views: 11