+ Reply to Thread
Results 1 to 2 of 2

Index Match array formula keeps displaying #N/A

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    London
    MS-Off Ver
    Office 2013
    Posts
    2

    Index Match array formula keeps displaying #N/A

    Hi all,

    I'm trying to use and index match formula to match two different cells and return the 3rd but it keeps coming up with the #N/a and I can't seem to figure out the error.

    This is the formula:

    {=INDEX(Sheet1!E1:E290,MATCH(1,(FINAL!C3=Sheet1!A1:A290)&(FINAL!B4=Sheet1!B1:B290),0))}

    I've checked using F9 that each part is looking up the right information and it looks like it is but it just doesn't want to work

    Please help!

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Index Match array formula keeps displaying #N/A

    You marked this solved but just to be sure, you want to replace the & with *

    {=INDEX(Sheet1!E1:E290,MATCH(1,(FINAL!C3=Sheet1!A1:A290)*(FINAL!B4=Sheet1!B1:B290),0))}
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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 [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2015, 12:06 PM
  2. [SOLVED] INDEX MATCH Array formula Help
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-28-2014, 10:01 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. Wrong result displaying using IFERROR-INDEX-MATCH-ROW Formula
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-16-2013, 01:03 PM
  5. Index, Match, Min, If, And in one Array formula
    By Skybeau in forum Excel General
    Replies: 1
    Last Post: 07-18-2012, 01:03 AM
  6. 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
  7. Index and Match Array formula
    By Graham Haughs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-15-2006, 09:55 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