Results 1 to 10 of 10

Using INDEX & MATCH returns #N/A just in some rows

Threaded View

  1. 04-05-2017, 12:37 AM #1
    omid020
    omid020 is offline
    Registered User
    Join Date
    02-24-2009
    Location
    Tehran
    MS-Off Ver
    Excel 2010
    Posts
    45

    Using INDEX & MATCH returns #N/A just in some rows

    I have used INDEX and MATCH for doing lookup with 2 parameters. It seems it is working fine in Column (R) of first sheet but some items like R26 returns #N/A and I can not find the reason; Could you please guide me?
    Attached Files Attached Files
    Last edited by omid020; 04-05-2017 at 07:24 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match (row and header) that returns the first non-zero value
    By jmanp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-05-2016, 04:10 PM
  2. [SOLVED] Index match that returns 0
    By Keldion in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-11-2016, 03:41 PM
  3. Index Match that returns all non zero values in row
    By kvarner in forum Excel Formulas & Functions
    Replies: 44
    Last Post: 03-03-2016, 06:41 PM
  4. [SOLVED] Index+Match+Match doesnt returns right values
    By SwissExcel in forum Excel General
    Replies: 10
    Last Post: 07-21-2015, 08:39 AM
  5. Sum of multiple Index Match returns!?
    By Spicey_888 in forum Excel General
    Replies: 6
    Last Post: 04-25-2015, 05:30 AM
  6. [SOLVED] Index/Match returns #N/A result
    By pjkcpa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2014, 02:23 PM
  7. Excel 2007 : Index Match returns 0
    By Martin Chamberlin in forum Excel General
    Replies: 6
    Last Post: 10-27-2011, 09:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1