Excel Vlookup with Partial Text Match

Hi,

Please tell how to perform vlookup in below scenario.

Sheet 1
Col A:

A1: my name is #asb#
A2: I live in #123#
A3: I work as #hgs# with #456#.

And I have to bring below data in front of correspondent cells of above table;

Sheet 2

Col A:

A1: my name is Vizal
A2: I live in #Austin
A3: I work as IT Manager with Soil Tech.

Thanks for the help in advance.

Sheet 1 may contains following record.

A4: #456# are my hobbies.

Sheet 2:

A4: Playing football and reading science fiction books are my hobbies.

Thanks.