+ Reply to Thread
Results 1 to 4 of 4

index match in array formula

  1. #1
    Registered User
    Join Date
    10-10-2018
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    10

    index match in array formula

    Capture.JPG

    Hi Everyone! Based on the picture above, can anyone tell me why the second formula returns #NA when both (right($D$2,4) and ($D$2) return "1024"?

    I just couldn't figure out why the second formula won't work?

    Note: The two formulas are inserted as Array Formulas.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: index match in array formula

    If D2 is entered as a NUMBER it is becaue RIGHT returns TEXT.

    Amend to RIGHT($B2:$B4,4)+0,etc instead of RIGHT($B2:$B4,4), etc
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    10-10-2018
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    10

    Re: index match in array formula

    Genius! Thanks for clearing up my confusion!!!!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: index match in array formula

    Many things... but no genius.

    You're welcome.



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

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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 and match array formula
    By mq1973 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-01-2018, 05:43 PM
  2. [SOLVED] Index, match, array formula.
    By hurrell8510 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-20-2017, 12:08 PM
  3. Replies: 3
    Last Post: 04-02-2016, 08:16 PM
  4. [SOLVED] INDEX MATCH Array formula Help
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-28-2014, 10:01 PM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. [SOLVED] Index and Match array formula - Help with this?
    By SwtSinSation in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2014, 09:51 AM
  7. Nested Match(index()) vs. Match() array formula.
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2011, 07:57 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