VLOOKUP and "contains"

Hi all,

I have a list of random addresses that may or may not be the full correct address according to a GVT database.

I have over 15000 lines of them and the GVT Database has over 120 000 lines.

I need a vlookup that can contain 'variables' to search the list of my addresses and lookup in the GVT database.


eg: MY ADDRESS

1. 19C St Georges

GVT DB:

1. Flat C 19 St George's Avenue London



Is there any way to do this.

Thanks for all and any help.