+ Reply to Thread
Results 1 to 6 of 6

Index and Match with an AND statement?

  1. #1
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Index and Match with an AND statement?

    Hello all again
    In over my head on this and would greatly appreciate the help with a formula
    In attached example I am trying to do the following

    I would like the result from Column M (Total RVU for Serv Date) to be populated into Column F (RVU from Visit date) as long as the MRN's in Columns A and H, the Provides in Columns C and J, and the Dates in Columns B and I are all match. I highlighted what I am trying to convey in yellow
    I hope this makes sense
    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,108

    Re: Index and Match with an AND statement?

    How about
    =SUMIFS(K:K,G:G,A2,H:H,B2,I:I,C2)

  3. #3
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: Index and Match with an AND statement?

    WOW ! I have never seen this type of formula/Configurtion.Any chance you could explain what this is doing so I dont have to bother anyone with this type of question again?...Many many thanks
    Amazing !

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,108

    Re: Index and Match with an AND statement?

    It's adding all the values in col K where G=A & H=B & I=C
    You could in-fact get rid of the formula in K & use this in F
    =SUMIFS(J:J,G:G,A2,H:H,B2,I:I,C2)

    As it basically does the same thing

  5. #5
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Re: Index and Match with an AND statement?

    Thanks again Fluff 13. Greatly appreciated !

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,108

    Re: Index and Match with an AND statement?

    You're welcome & thanks for the feedback.

+ 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. Index Match with and If statement
    By SouthernMeMe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2019, 11:16 AM
  2. Index/Match with if/or statement
    By fjd9189 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-20-2019, 12:25 PM
  3. [SOLVED] Using an IF statement with INDEX / MATCH
    By Fermented Reptile in forum Excel General
    Replies: 3
    Last Post: 02-13-2017, 08:47 AM
  4. index match with if statement
    By Per_s in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2016, 08:48 AM
  5. [SOLVED] If Statement (Match/Index)
    By usmanfarok in forum Excel General
    Replies: 12
    Last Post: 09-26-2012, 04:42 AM
  6. Index & Match with IF statement
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2007, 01:49 PM
  7. Index() & Match() or just an if() Statement?
    By JustMe602 in forum Excel General
    Replies: 6
    Last Post: 12-12-2006, 04:24 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