+ Reply to Thread
Results 1 to 3 of 3

Equivalent of an index match but return all values that meet the criteria

  1. #1
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    179

    Equivalent of an index match but return all values that meet the criteria

    Hi all,

    I'm a little bit stuck with something - hope you can help.

    Is there a custom formula that can be created (or even just an excel formula) to do the equivalent of an index match but return all values that meet the criteria, rather than just the first instance? I have the lookup value in A1, the lookup range is P4:P1000 and the return range is J4:J1000.

    Thanks for your anticipated help.
    Did I help? Click *- add to my rep.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Equivalent of an index match but return all values that meet the criteria

    Hi Brumbot,

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: Equivalent of an index match but return all values that meet the criteria

    Quote Originally Posted by xladept View Post
    Hi Brumbot,

    Try this:

    Please Login or Register  to view this content.
    Hi xladept,

    This works great, and makes perfect sense too Thankyou. I will have to remember this for later use.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Equivalent of an index match but return all values that meet the criteria

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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