Hi,
I am trying to match a portion of the text in a given array and return the corresponding complete value of the array.

Example:

A B C
command command command
exc axisid excel
metrics myer prop sport metrics
myer plc sports metrics myer prop
axis pty excel axisid
pivot toblerone pivott table
toble pivott table toblerone
chair 6 chair 6 chair

Column A is the value that I want to search in Column B. IF full/part of column A is present in Column B, then display the complete text of column B in Column C. Coloumn C is the output I want to get.

However, I am able to get all value with the formula
=VLOOKUP("*"&A4&"*",B$4:B$11,1,FALSE).

except, for 4th and 5th line as Column A contains more words that are not in Column B.

I would appreciate if you could assist me on this.

Cheers,
Ai