Hi

I need to edit my excel worksheet in such a way as shown:

A1 data is: x/Makhushi?fref=
A2 data is: w/m/x/jeorge?fref=

D1 data is: David is going home
D2 data is: jeorge is fine
D3 data is: is Makhushi a good boy


I want B columns as by matching subtext in column A and D
B1: Makhushi a good boy
B2: jeorge is fine

How do I achieve this if I have data up to 500 ROWS ?
PS: TEXT CAN BE MISSING IN ANY CELL. matching text must be case insensitive.

Please help.