+ Reply to Thread
Results 1 to 3 of 3

Problem with index and match formula

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    Problem with index and match formula

    Hi All,
    Pls see attached relevent file.
    i'm not sure why i'm not getting the values for "2" item in the summary table.
    I'll appriciate your help,
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Problem with index and match formula

    Try

    C45=IFERROR(IFERROR(INDEX($C$23:$F$39,MATCH($B45,$B$23:$B$39,0),MATCH(C$43,$C$22:$F$22,0)),0)+IFERROR(INDEX($C$2:$F$19,MATCH($B45,$B$2:$B$19,0),MATCH(C$43,$C$1:$F$1,0)),0),"-") and drag towards the cell
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Problem with index and match formula

    Or

    =SUMIF($B$2:$B$39,$B45,F$2:F$39)

    Assuming row labels are present in summary.
    Last edited by JohnTopley; 06-01-2016 at 03:20 AM.

+ 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. [SOLVED] Index match formula problem
    By nellyc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2013, 06:37 AM
  2. index/match formula problem
    By pma85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 01:49 PM
  3. Problem with Index and Match formula
    By annupojupradeep in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2013, 08:01 PM
  4. [SOLVED] Problem with my INDEX and MATCH formula
    By eoghanmolloy in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-19-2012, 01:10 PM
  5. Problem with Index and Match Formula
    By rbpd5015 in forum Excel General
    Replies: 1
    Last Post: 12-01-2011, 10:38 AM
  6. I'm having a problem with a Index/Match formula
    By PaulEast in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2011, 07:38 AM
  7. Problem with Index/Match formula
    By djfatboyfats in forum Excel General
    Replies: 7
    Last Post: 05-18-2009, 08:29 AM
  8. Problem with INDEX & MATCH formula
    By tuph in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2007, 07:12 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