Find the Country in a set of words

[datastudent]

Hi,

I don't know how to explain this clearly so please be patient with me.

In column C, I have a formula where I look for the "Fixed" and "Mobile" only. What I want is to also show the country name if in column A it only show the country name as shown below.

Template_v1.xlsm
	A		C
3	Outbound Destination		a
22	Australia		Australia
23	Australia Emergency
24	Australia Fixed		Fixed
26	Australia Mobile		Mobile
52	Brazil		Brazil
53	Brazil - EMS
54	Brazil - Freephone
55	Brazil - Mobile		Mobile
81	Czech Republic		Czech Republic
82	Czech Republic 112
83	Czech Republic Freephone
84	Czech Republic Mobile		Mobile
85	Czech Republic Shared
iBASIS_Outbound

Cell Formulas
Range	Formula
C23:C24,C26,C82:C85,C53:C55	C23	=IFERROR(ARRAYTOTEXT(REGEXEXTRACT($A23,"Mobile|Fixed",1)),"")

 

[datastudent]

What about the second formula I suggested?
If that also does not work (hard to tell when most of the rows of the sample data are hidden) then I am in agreement with Eric that a lookup table would be required.

Yea both formula shows the same problem. Some country is not recognized.

Can you please help me with my follow up question(post #5) above

 

[datastudent]

Okay I will add the Country code. But I still want to show the "Fixed" and "Mobile". How do I combine that to the initial formula?

=LET(c,Note!$E$2:$E$80,mf,{"Mobile","Fixed"},XLOOKUP(A4,c,c,XLOOKUP(TRUE,ISNUMBER(SEARCH(mf,A4)),mf,"",0),0))

Actually nevermind. I figured it out. Thanks!