+ Reply to Thread
Results 1 to 3 of 3

Row and column match? (IF INDEX MATCH) What am I doing wrong.

  1. #1
    Registered User
    Join Date
    01-02-2015
    Location
    Europe
    MS-Off Ver
    2011
    Posts
    2

    Unhappy Row and column match? (IF INDEX MATCH) What am I doing wrong.

    Good day.

    I have a problem with my output. (Ive attached the test file here)
    Team-Test1.xlsx

    B3:B6 is setup with type of cars and C2:F2 is set up with teams.
    Between C3:F6 i have different weeks, and what i am trying to is that i can make a list that tells me what team i have that has the competence to handle the car in a given week.

    So in my example i have also listed Week1-Week4 in H3:H6, Type of Car in I3:I6 and Team w/Competence in J3:J6.
    In I3:I6 i can write what ever car i want, to be able to see in J3:J6 what teams that have the competence in the given weeks in H3:H6.

    -If you take a look in the example file you can see that the code in J6 outputs the correct answer, but J3-J5 doesn't.
    -There is where my problems are. (The code is something i got from another excel project that seem to be similar)

    Sorry if i didn't explain myself properly

    Best regards,
    Noop

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Row and column match? (IF INDEX MATCH) What am I doing wrong.

    Change your your formula as =IF(I3="","",INDEX($C$2:$F$2,MATCH(H3,INDIRECT("C"&MATCH(I3,$B$1:$B$6,0)&":F"&MATCH(I3,$B$1:$B$6,0)),0)))
    can try the below too
    =INDEX($C$2:$F$2,MATCH($H3,INDEX($C$3:$F$6,MATCH($I3,$B$3:$B$6,0),),0))
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-02-2015
    Location
    Europe
    MS-Off Ver
    2011
    Posts
    2

    Re: Row and column match? (IF INDEX MATCH) What am I doing wrong.

    That worked so perfect!! Thank you very much nflsales!

    While we're on the subject, i'm just a excel beginner when it comes to what i call advance excel
    Do you or anyone have anything to recommend for learning more? With examples and explanation of each function etc?

    Really happy i singed on to this forum, can't wait to learn more

+ 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. Index match matches the wrong column
    By Jonathan9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-21-2014, 12:51 AM
  2. [SOLVED] Index and Match... I'm pretty sure I'm just doing it wrong
    By rstarr1 in forum Excel General
    Replies: 2
    Last Post: 10-13-2014, 05:40 PM
  3. [SOLVED] What's wrong with this Index Match/Row formula?
    By DaveBre in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-25-2014, 08:37 PM
  4. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  5. Index and Match-wrong value
    By Steved in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2005, 07:06 PM

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