Results 1 to 2 of 2

Index and Match not returning the correct value

Threaded View

karstens Index and Match not returning... 02-22-2021, 10:51 PM
Gregb11 Re: Index and Match not... 02-22-2021, 10:59 PM
  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    213

    Index and Match not returning the correct value

    I am trying to do the index and match function and all my results come back NO when there should be some YES and #NA.
    I have uploaded an example.
    So basically I use a DATABASE tab to look up on the Report Filter tab for a match. I am looking at two columns, a code and description. On the report filter tab, it lists code, description and YES or NO if it it should be used for reporting.
    If a match is found on both tabs, then it should return the answer yes, no or #NA on the database tab. I am using excel 365.
    Thanks in advance for your expertise.
    Attached Files Attached Files
    Last edited by karstens; 02-23-2021 at 10:15 AM.

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 Not returning Correct Value
    By onp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-21-2020, 02:28 PM
  2. [SOLVED] Index Matrix not returning correct value
    By JasXel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-08-2018, 06:59 AM
  3. Index and Match formula not returning correct values
    By rcdavis28 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2016, 05:25 PM
  4. Replies: 11
    Last Post: 01-12-2016, 03:30 PM
  5. [SOLVED] Index Match formula not returning correct results
    By JennOlsen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2015, 02:59 PM
  6. Replies: 3
    Last Post: 12-17-2014, 02:05 PM
  7. [SOLVED] IFERROR+INDEX+MATCH Formula is not returning the correct value
    By bxk006 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2013, 09:50 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