+ Reply to Thread
Results 1 to 2 of 2

Match then Return Relative Reference that Also Matches

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Virginia, USA
    MS-Off Ver
    2007
    Posts
    63

    Match then Return Relative Reference that Also Matches

    Hello,

    I've got a formula that will look at a unique ID and match that to an array that has multiple records sorted in ascending order by unique id. My goal is to match the ID and return only the applicable record(s). My problem is that sometimes the number of records are inconsistent. One ID may have two records another one may have 4 (or even none). My current formula takes a lot of proofreading because of this and I am hoping to do more proofing in the formula. Any help is greatly appreciated. Here is what I have:

    A7:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    A8:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <--Looks at next row in list
    A9:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <--Looks at the 2nd row in the list
    relative to starting cell

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,020

    Re: Match then Return Relative Reference that Also Matches

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. [SOLVED] Search and return text that matches a reference
    By JSTR250 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2015, 05:28 AM
  2. [SOLVED] Return value when part of a cell matches a word in a reference column
    By crazyb78 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-29-2015, 05:28 AM
  3. Replies: 0
    Last Post: 07-26-2015, 09:14 PM
  4. [SOLVED] Index Match return highest value in repeated matches
    By izk630 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-30-2015, 04:09 PM
  5. Index Match return highest value in repeated matches
    By izk630 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-29-2015, 12:57 PM
  6. Can Match return a validation list when it has several matches?
    By ggiorelli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 07:22 AM
  7. Replies: 2
    Last Post: 08-16-2012, 09:00 AM

Tags for this Thread

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