+ Reply to Thread
Results 1 to 6 of 6

if error index match issue

  1. #1
    Registered User
    Join Date
    04-11-2015
    Location
    Atlanta, Ga
    MS-Off Ver
    2013
    Posts
    9

    if error index match issue

    I'm trying to do an iferror index match, but the value is a word in the column but it is showing blank in the ones that has the words in there. The value needs to be blank if there is no skill level in the particular column but if there is a skill level it needs to put the value/skill level that is listed. What am I doing wrong? This is my formula: =IFERROR(INDEX('Student Data'!A9:A95, MATCH(B9:B95,'Student Data'!J8:J94),match B3:B12110),"") Can anyone help?
    lesson5problem.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: if error index match issue

    Hi, welcome to the forum

    Try this (you were almost there)...
    =INDEX('Student Data'!$B$8:$K$94,MATCH('Lesson Data'!$B3,'Student Data'!$A$8:$A$94,0),MATCH('Lesson Data'!F$2,'Student Data'!$B$7:$K$7,0))

    A few comments on what you had...

    1. Add the error-trapping (IFERROR) avfter you have the basic formula working. It adds nothing to the formula it'self and only stops error messages from showing
    2. match expects a single cell as the 1st argument, not a range - this is what you want to find
    3. learn to use the Fx button to the left of the formula bar. It will walk you through what the formula expects, and ID errors in syntax or ranges for you.
    Last edited by FDibbins; 04-11-2015 at 08:13 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-11-2015
    Location
    Atlanta, Ga
    MS-Off Ver
    2013
    Posts
    9

    Re: if error index match issue

    Thank you !!!!!!!!!!!!!!!!!!!!!! It worked great!!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: if error index match issue

    you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)

  5. #5
    Registered User
    Join Date
    04-11-2015
    Location
    Atlanta, Ga
    MS-Off Ver
    2013
    Posts
    9

    Re: if error index match issue

    I have not been able to get the IF function to work. I first thought it was IFERROR but upon reading the problem over it just asked for IF.
    Last edited by trinialaskan; 04-12-2015 at 09:44 AM.

  6. #6
    Registered User
    Join Date
    04-11-2015
    Location
    Atlanta, Ga
    MS-Off Ver
    2013
    Posts
    9

    Re: if error index match issue

    ok I guess I was really tired last night because I found the "solved" really easy this morning.
    Last edited by trinialaskan; 04-12-2015 at 09:45 AM.

+ 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. Issue: Only returning 1st match on Index/Match
    By tbr2891 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2014, 11:54 AM
  2. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  3. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  4. [SOLVED] MATCH-INDEX issue
    By vichisov in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-17-2013, 12:59 PM
  5. index match issue
    By jw01 in forum Excel General
    Replies: 2
    Last Post: 04-25-2012, 12:10 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