Excel 2007 : VLookup - Return "suburb" from string of characters

Hi Guys,

I'm sure this might seem as a small problem too many, but to me its so difficult.

I have a list of addresses dump from a system. The cell has the whole address in one cell. I have tried separating by delimiting "space" but some suburbs have multiple words and causing me grieve. I have 25 000 lines.

PLEASE Help. Me begging.

Example:

(String of characters in on cell)
17 DE LAAN GLEN MARAIS KEMPTONPARK
1 BENNETT AVI COMET BOKSBURG
1 AGTSTE STR FOCHVILLE 2515
1 DIETERSTRAAT BIRCHLEIGH NOORD 1618


Now I have a list of Suburbs

Example

KEMPTONPARK
BIRCHLEIGH NOORD
FOCHVILLE

I need to return

The suburb from the string of characters. It need to match and return.

Please help me ...urgently.

Thanks

Thanks protonLeah.

Gee, this code is AWESOME.

I really really appreciate it

Thanks,