How to search for a cell containing text referenced from another cell

[htankersley]

I am looking to find cells based on strings in other cells. Example:

Range	Search Criteria	Formula	Output
ugh Help me	23	find B2 in A2:A4	A3
please 23 why	learning	find B3 in A2:A4	A4
I am learning, I promise	help me	find B4 in A2:A4	A2

What formula should I be using to get the output?

PLEASE AND THANK YOU!

[#2]

@htankersley 

="A"&MATCH("*"&B2&"*",$A$2:$A$4,0)+1

You can try this formula which returns the expected result in my sheet.