Lookup values from sheet 2 with sheet 1 and copy found values in cell b of sheet 1

I have two sheets 1 and sheet 2..I have some text cells in sheet 2 which I want to lookup in sheet 1's data. but problem is that those values of sheet 2 found in between the sentences..like

in sheet 2 I have
ColA
mayur vihar
preet vihar
pandav nagar

in Sheet 1 I have
ColA
A6/10, Jain Market,, Patparganj Rd, Block C, Acharya Niketan, Mayur Vihar, New Delhi, Delhi 110091
G-12/A,Commercial Complex, Savitri Sadan, Preet Vihar, Block D, Preet Vihar, New Delhi, Delhi 110092
E-8, Pandav Nagar, Patparganj, Pandav Nagar, Block S, New Delhi, Delhi 110092
Block C, Acharya Niketan, Mayur Vihar, New Delhi, Delhi 110091
Shop No. 108 Market -2, pandav nagar, Chittaranjan, C.R Park, Delhi 110019

Now I want to compare sheet 2 data with sheet 1 and copy the similar data in COl B of Sheet 1 so That
Sheet 1 Col B would be
Mayur vihar
Preet Vihar
Pandav Nagar
Mayur Vihar

Please help me to solve this issue..

Many Many Thanks in advance..

Try this

Run in attached file with {CTRL} + t

Please Login or Register  to view this content.

NOTE
USE FILE ATTACHED TO NEXT POST - this was incorrect version
oops!

I uploaded the incorrect file in post#2

Good.
Thanks for the reps
K