+ Reply to Thread
Results 1 to 4 of 4

Postcode Match: Cross Reference from another list

  1. #1
    Registered User
    Join Date
    12-01-2008
    Location
    London
    Posts
    25

    Postcode Match: Cross Reference from another list

    Hope to solve this problem (have checked the archive - have found similar examples & problems but the solutions offered in these did not seem to work)

    Simple case of wanting to match a postcode County and Country from a table containing this data.

    I think it is a combination of INDEX and MATCH, entered as an array - although, I have also tried an OFFSET - but as you can see from the snapshot this is not working.
    Postcode Match.jpg

    I enclose the spreadsheet with my failed effort.
    Appreciate everybody's time here.
    Many thanks
    denise
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Postcode Match: Cross Reference from another list

    In B2 Cell of Sheet1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down and right...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    12-01-2008
    Location
    London
    Posts
    25

    Re: Postcode Match: Cross Reference from another list

    Solved Sixthsense! Thank you so much - I would have never got to that formula in a million years! You did it in an nanosecond.
    Appreciate your time and effort Sixthsense. Will mark as solved
    best regards
    denise

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Postcode Match: Cross Reference from another list

    Glad it helps you and thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Match and VLookup to cross reference data
    By MrO in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-05-2013, 03:53 PM
  2. Closest Match Cross Reference Table
    By Jonathan78 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-08-2013, 05:20 PM
  3. Replies: 2
    Last Post: 10-11-2012, 08:05 AM
  4. Replies: 4
    Last Post: 04-26-2011, 04:38 PM
  5. Replies: 3
    Last Post: 04-21-2006, 12:13 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1