Guys,

I have been self sufficient in excel for many years and prided myself on not needing help. Times are a changing. Help!! I want to match a list thats similar to another list and show the 2nd column. However using a vlookup non exact match doesn't work for all of these. Any assistance would be appreciated I tried using the fuzzy logic addin and I couldn't make that work.

I have a table as such the one below but this will repeat itself in similar permutations:
Delivered to
OLD VICTORY PUB BARLOW STREET , LONDON SE17 1HW
26 FULHAM BROADWAY
26,FULHAM BROADWAY
/26 FULHAM BROADWAY
ELVER GARDENS BETHNAL GREEN LONDON , E27AZ
ELVER GARDENS BETHNAL GREEN LONDON , E2 7AZ
LIVERPOOL ST
LIVERPOOL STREET
21 WINDMILL AVENUE
32 BARLOW STREET
32 FARLOW STREET
CLIFTON HOUSE 101 EUSTON ROAD , LONDON NW1 2RA
ELVER GARDENS BETHNAL GREEN , LONDON E2 7AZ
STEVEN STREET

And I want to match the above to the following :
Weekly Reports Site Code
SITTINGBOURNE - 40 GLEEBE LANE CHAL13PD01
LIVERPOOL STREET 0001476/11
CLIFTON HOUSE 0001458/10
ELVER GARDENS ELVGHI0001
WOOLWICH 0001468/11
FULHAM BROADWAY FULHROM000
21 WINDMILL AVENUE WINDMAD001
32 BARLOW ST FULHROM001