+ Reply to Thread
Results 1 to 2 of 2

Index, Match formula returns #NA error if result is from an average formula.

  1. #1
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Asheville NC
    MS-Off Ver
    Excel for Office 365 MSO
    Posts
    111

    Index, Match formula returns #NA error if result is from an average formula.

    I am using an average formula in several cells and then trying to use an "index match" formula to return a cells info from a matching value. Why will the formula return an error if the result is from using an average formula (see attachment) but works if I use a result that does not use an average formula (hard number)? If I reverse the index match formula, it also works.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Index, Match formula returns #NA error if result is from an average formula.

    G8 does not = EXACTLY 0.439
    If you expand out the decimals beyond 3, you'll see G8 actually equals
    0.4390909infinity0909

    Change the average formula in G8 to
    =ROUND(AVERAGE(G9:G11),3)

+ 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. Replies: 4
    Last Post: 04-28-2014, 07:24 PM
  2. [SOLVED] index & match formula with two criteria that returns answer from chart
    By jamied2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2014, 09:50 AM
  3. [SOLVED] Index/Match returns #N/A result
    By pjkcpa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 02:23 PM
  4. [SOLVED] INDEX MATCH function returns result #N/A
    By morrisondan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-22-2013, 03:01 PM
  5. [SOLVED] MATCH/INDEX Formula Returns an Error Instead of 0
    By livifivil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2013, 04:18 PM
  6. [SOLVED] Formula whit INDEX and MATCH. I try to make this formula to result.
    By Anka in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2012, 06:26 PM
  7. [SOLVED] Looking for formula index/match-type that returns an array
    By Tom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2005, 05:06 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