+ Reply to Thread
Results 1 to 2 of 2

Index/Match Return is an Error but Only at the Top of List

  1. #1
    Registered User
    Join Date
    05-20-2015
    Location
    Summit, NJ
    MS-Off Ver
    2010
    Posts
    1

    Index/Match Return is an Error but Only at the Top of List

    Hi – I was searching the forums for an answer to this, with no luck, and I was hoping someone could help.

    I am using an index/match to return (a name) from the row above (the name) in worksheet "Mtg Portfolio Data". The name to search comes from a dropdown menu in cell B1 on worksheet Peer Comparison

    =IFERROR(INDEX('Mtg Portfolio Data'!$A$3:$A$220,MATCH('Peer Comparison'!B1,'Mtg Portfolio Data'!$A$3:$A$220,0)-1,1),"")

    The formula does exactly what I want, except when the name in cell B1 is on top of the list (in cell A3). In this instance the return is “+2”.

    A
    B
    C
    D
    E
    If I choose B, I get A, which is what I want.
    If I choose A, I get C.. which I don’t understand. I want an error/blank.
    Last edited by kate isgreat; 05-20-2015 at 04:34 PM.

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

    Re: Index/Match Return is an Error but Only at the Top of List

    Scrap that ... should have looked at the formula more closely.

    Please post a sample workbook.

    Regards, TMS
    Last edited by TMS; 05-20-2015 at 06:22 PM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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] Use index/match to return a list of values
    By mustangsally in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2014, 04:00 PM
  2. Index/match formula - return #n/a error
    By jBailey031285 in forum Excel General
    Replies: 2
    Last Post: 03-13-2012, 05:53 PM
  3. Want Index and Match to return Error
    By dasafacjack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2011, 03:09 PM
  4. Return list of values index/match
    By spivieguy1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2009, 02:49 PM
  5. [SOLVED] Error Return Value from and INDEX(A:2,MATCH()) function
    By BJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-26-2005, 11:06 AM

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