+ Reply to Thread
Results 1 to 2 of 2

Multi Criteria Index and Match - Getting #NA Error

  1. #1
    Registered User
    Join Date
    10-07-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Multi Criteria Index and Match - Getting #NA Error

    I am using this formula =INDEX('Expense Data'!F$9:F$146,MATCH(1,('Expense Data'!$B$9:$B$146=$A25)*('Expense Data'!$A$9:$A$146=A$6),TRUE)) to look up a department and account to return the amount for that period. I noticed that when an account does not show up in the data if is looking up it gives me an #NA error message.

    Any idea how I can run this formula and without getting the #NA and it just display 0?

  2. #2
    Forum Contributor
    Join Date
    10-02-2012
    Location
    Bumi Nusantara
    MS-Off Ver
    Excel 2010; Excel 2016
    Posts
    136

    Re: Multi Criteria Index and Match - Getting #NA Error

    syntax for Match is
    =Match(lookup_value , lookup_range , [match_type] )
    match_type is should be -1, 0, or 1
    not True or False

    or you may post your sample if it still getting error

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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