Results 1 to 17 of 17

INDEX MATCH works for some cell not others

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-15-2005
    Location
    Florida
    MS-Off Ver
    Excel Professional Plus 2016
    Posts
    153

    INDEX MATCH works for some cell not others

    So, I thought I somewhat mastered simple INDEX MATCH FUNCTION. The function works for some and not others cells.

    I use: =INDEX(Helper!B:B,MATCH(B2,Helper!A:A,0)) and do the ctrl + shift + enter

    Worksheet "DATA" A2 has a #NA but A3 gives me the results.

    I checked the logic and the result should be "PALM BEACH MARKET"

    Is there an explanation or is this a glitch in the function?

    Thank you,
    Attached Files Attached Files
    Last edited by rogrand; 08-08-2021 at 07:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] This formula works but I donīt understand why Index(Index) match
    By campelliann in forum Excel General
    Replies: 2
    Last Post: 01-25-2016, 05:55 PM
  2. Replies: 6
    Last Post: 01-19-2015, 10:27 AM
  3. Replies: 1
    Last Post: 05-08-2014, 10:21 AM
  4. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. [SOLVED] INDEX/MATCH works on SOME, but not ALL
    By x65140 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2014, 07:44 AM
  6. Index/Match works in some cells, not in others
    By tenalp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-12-2012, 08:29 PM
  7. index/match search works in some cells, but not others?
    By pythonscript in forum Excel General
    Replies: 2
    Last Post: 07-06-2011, 08:32 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