Results 1 to 2 of 2

Thread: Lookup lookup lookup just can't make it work

  1. #1
    Junior Member
    Join Date
    Dec 2012
    Posts
    1
    Rep Power
    0

    Lookup lookup lookup just can't make it work

    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

  2. #2
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    13
    work2live,

    Welcome to the forum.
    It would be easier to see what you are trying if you attach a workbook.

Similar Threads

  1. Sum Based on Lookup
    By wsadaqa in forum Excel Help
    Replies: 3
    Last Post: 05-20-2013, 09:17 AM
  2. Lookup Based on Criteria
    By maruthi in forum Excel Help
    Replies: 2
    Last Post: 02-15-2012, 08:49 AM
  3. Lookup Formula
    By excel_learner in forum Excel Help
    Replies: 1
    Last Post: 02-01-2012, 03:08 PM
  4. Split Cell and Lookup
    By bsiq in forum Excel Help
    Replies: 4
    Last Post: 11-21-2011, 10:03 PM
  5. Lookup on Multiple Criteria
    By ramakrishnan in forum Excel Help
    Replies: 4
    Last Post: 09-15-2011, 10:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •