Find text and then show text

[Obewan]

In column A I have a list of all different words and name but the main issue is this - this appears in cell A113 but also there will be other names in this column - this is the name of a dog I am trying to replicate in another column (i.e. the bold text)
WILLIAM BALEBKW / D Jul-21 Allen Deed x Dyna Chill

I have it's name in column AR (i.e. AR13) - but the row should be irrelevant as long as it's within the range - i.e. rows 2:4250
WILLIAM BALE

So what I am trying to do is write a formula that says:
- if the text in column AR2:AR4250 can be found in columns A2:a4250 can it write that name in column X - therefore at X113 it would answer WILLIAM BALE

They are on completely different row so I need to cover rows 2:4250 and be able to drag the formula down row X from 2:4250

Hope that makes sense?

rergards

Seamus

 

[Obewan]

Sorry I had columns in wrong order

Book5
	A	B	C
1	Data	Output	Criteria
2			WILLIAM BALE
3			OBLIGING CYNDIE
4			LET'S WIN MINDEE
5			YOGI'S BABY
6			VACANT BOX
7			BEIJING LING
8			CHIPPED PENNY
9			MICK'S GAL
10			Tips:
11
12
13
14	WILLIAM BALEBKW / D Jul-21 Allen Deed x Dyna Chill	WILLIAM BALE
15	Trainer: Juanita Thompson (Tungamull)Owner: Bradley Mulvihill
16	Prizemoney: $160
17	Rating:97
18	Our Price:$2.4
19	Date
20	MON
Sheet1

Cell Formulas
Range	Formula
B2:B10	B2	=IF(ISNUMBER(MATCH("*"&C2&"*",$A$2:$A$5,0)),C2,"")
C11:C20	C11	=IF(ISNUMBER(MATCH("*"&#REF!&"*",$A$2:$A$5,0)),#REF!,"")

disregard the formulas that cam with it

 

[Obewan]

Book5
	A	B	C
1	Data	Output	Criteria
2			WILLIAM BALE
3			OBLIGING CYNDIE
4			LET'S WIN MINDEE
5			YOGI'S BABY
6			VACANT BOX
7			BEIJING LING
8			CHIPPED PENNY
9			MICK'S GAL
10			Tips:
11
12
13
14	WILLIAM BALEBKW / D Jul-21 Allen Deed x Dyna Chill	WILLIAM BALE
15	Trainer: Juanita Thompson (Tungamull)Owner: Bradley Mulvihill
16	Prizemoney: $160
17	Rating:97
18	Our Price:$2.4
19	Date
Sheet1

 

[Obewan]

Can anyone answer this based on the table above? Other fomrmulas provided have the answer at row2 but I need it at row 14.

Thanks

 

[Peter_SSs]

Like this? (I am assuming no more than one value from column C will appear in a single column A cell.)

23 09 07.xlsm
	A	B	C
1	Data	Output	Criteria
2			WILLIAM BALE
3			OBLIGING CYNDIE
4			LET'S WIN MINDEE
5			YOGI'S BABY
6			VACANT BOX
7			BEIJING LING
8			CHIPPED PENNY
9			MICK'S GAL
10			Tips:
11
12
13
14	WILLIAM BALEBKW / D Jul-21 Allen Deed x Dyna Chill	WILLIAM BALE
15	Trainer: Juanita Thompson (Tungamull)Owner: Bradley Mulvihill
16	Prizemoney: $160
17	Rating:97
18	Our Price:$2.4
19	Date
Sheet4

Cell Formulas
Range	Formula
B14:B19	B14	=FILTER(C$2:C$10,ISNUMBER(SEARCH(C$2:C$10,A14)),"")