+ Reply to Thread
Results 1 to 1 of 1

Wrong result displaying using IFERROR-INDEX-MATCH-ROW Formula

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,248

    Post Wrong result displaying using IFERROR-INDEX-MATCH-ROW Formula

    Dear Sir,

    I have enclosed here one in attachment and another a link for your kind perusal two workbook.First Workbook as enclosed in attachment in which the formula is correct.Second Workbook shown in link given namely-Formula for 5 lacs in which the same formula I have tried in column B5 but that formula does not work with the same data which is in First workbook as enclosed in attachment.Can you help me what's wrong in the formula.
    Kindly rectify the formula that is in B5 without any changes in any other column formula.

    https://skydrive.live.com/redir?resi...K8lTno-_obVCW4

    Any how thanks for those who tries to help me.

    With Best Rgds,

    Suresh
    Attached Files Attached Files
    Last edited by paradise2sr; 07-16-2013 at 01:24 PM.

  2. #2
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: Wrong result displaying using IFERROR-INDEX-MATCH-ROW Formula

    Instead of ROW($A3) use ROWS(A$3:A3)
    Last edited by wfm007; 07-16-2013 at 03:07 PM.
    Please consider adding a * if I helped

+ 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. VBA Index/Match/iferror/and comparision and update file through two different sheets
    By gaurangaero in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2012, 11:33 AM
  2. comparision between two excel sheet using VBA Code for Index/match/and/iferror formula
    By gaurangaero in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2012, 10:08 AM
  3. Looking for better formula of iferror, index and match
    By DavidRoger in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2012, 07:50 AM
  4. [SOLVED] Index and Match combination producing the wrong result
    By Authentik8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2012, 11:01 AM
  5. Index Max Match formula returning wrong value
    By bk77 in forum Excel General
    Replies: 4
    Last Post: 03-25-2009, 02:17 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