+ Reply to Thread
Results 1 to 2 of 2

Using Indirect & Match and getting N/A resutls

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    Frankfort, Ky
    MS-Off Ver
    Excel 2010
    Posts
    4

    Using Indirect & Match and getting N/A resutls

    I am using an Indirect & Match function to build a summary type spreadsheet. The problem lies that on the other spreadsheets when there is no match it returns a N/A result. What I would like the N/A to be is a 0. What is the simplest way to accomplish that? Here is a copy of the formula. =INDIRECT("'BusinessReport-2012'!P" &MATCH(A7,'BusinessReport-2012'!A:A,0))

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

    Re: Using Indirect & Match and getting N/A resutls

    Try

    =IFERROR(INDEX('BusinessReport-2012'!P:P,MATCH(A7,'BusinessReport-2012'!A:A,0)),0)

+ 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. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 PM
  2. Needing to move resutls from one sheet to another
    By Smoke14 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2008, 07:10 AM
  3. [SOLVED] Getting a chart to stop if the formula resutls in a blank cell
    By markag in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2006, 11:05 AM
  4. #N/A resutls in Vlookup when there is a match
    By egamalaki in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] same formula giving diff resutls
    By [email protected] in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2005, 01:05 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