Fernandez30
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.