Return text within a text cell

Hi, I'm stuck. I need excel to check if a cell has the text in A20 (let's say it's "Asc"), and for it to check the array of A1:A:10.
Now, the Asc sometimes will appear on it's own and this is easy, but often it will appear in a similar way as below (i.e. as parts of several text strings within the cell), but each time it will be different (sometimes it will be third word, sometimes forth, sometimes first like below, etc). So, I can not use left,right,mid functions either as I dont know when it will appear in what position.

MATCH doesn't work, as it only works if in the cell we only have Asc, if we have more strings (like below) then it doesn't work.

----------example----------------
A1: Asc Ke Ra Ma
A2: Sa Ve
A3: Mo
A4: ... etc
--------------------------------

So, how do I do it?

I need it, so that I can then make excel return me an index value in a next cell from where the Asc was found (I know how to do that part with index function)

Any help?

You can use wildcard characters with MATCH (and with VLOOKUP, which might be more compact than INDEX/MATCH), so you could do this:

=IFERROR(INDEX(B1:B10,MATCH("*"&A20&"*",A1:A10,0)),"")

Hope this helps.

Pete

Or:

=VLOOKUP("*"&A20&"*",$A$1:$B$19,2,0)