Formula to write name when seen in text

[Obewan]

I have a long list of text (maybe 4,500 lines) and I need a formula that identifies the name of a dog when it sees it in Column A - it may appear more than once - and then writes it as the answer in column B. The name is spelt correctly in Column C but not in Column A as it has extra characters attached to it. In the sheet below the data is all in column A, the answer to the formula I need to drag down column B and the actual name appears in column C. I need the answer to be the green highlighted cell. The formula needs to cover rows 2:4500. The actual name will always appear in column C before the name in column A. The fomrula would identify all names in Column C ats it sees them in Column A. See example below:

Book5
	A	B	C
1	Criteria	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
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

 

[Anonymous1378]

See if this works for you? I'm assuming only one dog name can appear in a cell, otherwise TEXTJOIN(FILTER()) would probably be the preferred approach.

Book1
	A	B	C
1	Criteria	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
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
B14	B14	=XLOOKUP(TRUE,ISNUMBER(SEARCH($C$2:$C$9,A14)),$C$2:$C$9,"")

 

[Fluff]

Duplicate to: Find text and then show text

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.