Results 1 to 6 of 6

Match Function Returning NA and Incorrect Values

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    36

    Match Function Returning NA and Incorrect Values

    I am extremely confused with what is going on in this file I was using. I understand the match function tells you the relative position of something in some given range, but the values it is giving me here seem totally wild. I get NAs sometimes when I change the text on the left, and other times I just get the wrong position (sometimes the right position). I am honestly beyond confused at this point as to what could possibly be going on (there is no consistency - I presume there must be something modified about the cells that I am not seeing). Please help, I beg.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Problems with INDEX, MATCH, MATCH returning incorrect values
    By Paul103 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2018, 05:16 PM
  2. [SOLVED] INDEX & 2x MATCH returning incorrect values
    By Dan_B in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-06-2017, 06:01 AM
  3. [SOLVED] MEDIAN IF Function returning incorrect values
    By karinprft in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2014, 03:48 AM
  4. [SOLVED] Index Match returning incorrect values
    By SomeDude0nline in forum Excel General
    Replies: 2
    Last Post: 07-23-2014, 10:20 AM
  5. Index match returning incorrect values
    By Mrpussalia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2014, 10:55 PM
  6. VLOOKUP and MATCH returning incorrect values
    By -Spax- in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-10-2011, 07:03 AM
  7. VLOOKUP returning incorrect values for unfound match
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-15-2010, 01:30 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