How do you search for text within text and then when you find a match, return
the information in the next column?

I usually use the functions index(match) to do the above. Unfortunately,
the function only works when there is a identical match.

So, I need to find 765849 in 111765849111 and then return the next column.

Thanks, I really appreciate the help!

Best regards,

Dave