+ Reply to Thread
Results 1 to 8 of 8

Index Match Function Not Working for One Field

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    8

    Index Match Function Not Working for One Field

    Unsure why it's happening, but it works for all of the other values.

    I have one table that has the following data I'm pulling as an index:

    Case Name | Flagged for Review
    7C-UCA | Yes
    7C-UCB | Yes
    7C-DAA | Yes

    Cases are listed in $A$2:$A$9
    Flagged for Review in $S$4:$S$9

    2nd Table has a list of Equipment tied to that Specific Case

    7C-UCA has 2
    7C-DAA has 6
    7C-UCB has 1

    I wanted to flag each line of the 2nd table if the 1st table says that case is flagged

    =INDEX($S$4:$S$10, MATCH(E14, $A$4:$A$10))

    Where E14 is the case number on that row.

    It works for 7C-UCA and 7C-UCB, but for some reason 7C-DAA results in a #N/A in the match function

    Any thoughts?

    Thank You!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Index Match Function Not Working for One Field

    Hi and welcome,

    Attach a sample workbook (not a picture or pasted copy). 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.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Index Match Function Not Working for One Field

    Quote Originally Posted by mleunis24 View Post
    Cases are listed in $A$2:$A$9
    Flagged for Review in $S$4:$S$9


    It works for 7C-UCA and 7C-UCB, but for some reason 7C-DAA results in a #N/A in the match function

    Any thoughts?

    Thank You!
    Check the bolded part you are speaking two different range size that's why it is not working.

    Better if your can upload a sample workbook with expected outcome.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Index Match Function Not Working for One Field

    @shukla
    Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding

    For normal conversational replies, try using the QUICK REPLY box below.

  5. #5
    Registered User
    Join Date
    02-11-2019
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    8

    Re: Index Match Function Not Working for One Field

    Attached!

    Still showing #N/A for 7C-DAA
    Attached Files Attached Files

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Index Match Function Not Working for One Field

    try

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

  7. #7
    Registered User
    Join Date
    02-11-2019
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    8

    Re: Index Match Function Not Working for One Field

    You are an angel, thank you!

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Index Match Function Not Working for One Field

    Glad to help you. Please add reputation by clicking star icon left corner on your screen on those post which helped you.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] INDEX MATCH function not working on filtered pivot
    By heytherejem in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-29-2017, 01:56 AM
  2. Index/Match function not working
    By tantcu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2017, 04:03 PM
  3. [SOLVED] Index, Match & And function doesn't seem to be working when there is duplicate data
    By penexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2013, 07:08 PM
  4. Index and Match function not working
    By Ystar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2013, 07:11 AM
  5. [SOLVED] Index/Match Function not working
    By melnemac32 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2013, 07:11 AM
  6. [SOLVED] ISNA with INDEX(MATCH) function not working
    By wyndland in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-22-2013, 11:37 PM
  7. Index-Match Function Not Working all the time
    By hoosierhunter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-08-2007, 06:58 PM

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