Find a text from a column in a text string within another column?
 

Hello,

I've read through posts and couldnt find an specific reply for my request,
I'm looking for a formula that lets me find a text C1, within a text string
contained in a range A:A, and return me the adjacent cell value of the string
into cell D1.
Text in Cell C1 may repeat in arrange A:A, but are few cases and wouldnt
matter if they did not return a value.

So it would look like this:
A B C D
TIMER COMPANY 1234 REX 1235
REX COMPANY 1235 COMPANY N/A#
ALPHA COMPANY 1236 TIMER 1234

Thanks a lot to the community.

Find a text from a column in a text string within another column?
 

Hi Mike

Try
=INDEX($B$1:$B$3,MATCH(C1&"*",$A$1:$A$3,0))

--
Regards
Roger Govier

"Mike Garcia" wrote in message
...
Hello,

I've read through posts and couldnt find an specific reply for my request,
I'm looking for a formula that lets me find a text C1, within a text
string
contained in a range A:A, and return me the adjacent cell value of the
string
into cell D1.
Text in Cell C1 may repeat in arrange A:A, but are few cases and wouldnt
matter if they did not return a value.

So it would look like this:
A B C D
TIMER COMPANY 1234 REX 1235
REX COMPANY 1235 COMPANY N/A#
ALPHA COMPANY 1236 TIMER 1234

Thanks a lot to the community.