+ Reply to Thread
Results 1 to 3 of 3

Index & Match Formula for Unique Values On Multiple Criteria

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Index & Match Formula for Unique Values On Multiple Criteria

    Dear Experts,

    Please find here attached workbook, In Sheet1 from Cell B7 the present formula is only based upon the criteria at Cell B5 and i want to include searching criteria for Cell B3 also to search in Forecast and Actual tabs for Income unique values. Request to you please do help me out on my thread.

    Thank you for your valuable support and precious phase.

    Regards,

    Neilesh

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Index & Match Formula for Unique Values On Multiple Criteria

    Hi

    in B6 (not in B7)

    Please Login or Register  to view this content.
    Array entered

    You cannot leave a blank cell between last title ("operating head) and first INDEX formula.

    Regards

    -----------------------

    Edit: please refer to the attachment
    Attached Files Attached Files
    Last edited by canapone; 03-24-2017 at 10:11 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Index & Match Formula for Unique Values On Multiple Criteria

    Quote Originally Posted by canapone View Post
    Hi

    in B6 (not in B7)

    Please Login or Register  to view this content.
    Array entered

    You cannot leave a blank cell between last title ("operating head) and first INDEX formula.

    Regards

    -----------------------

    Edit: please refer to the attachment
    Dear Expert,

    Thank you so much for your precious support and valuable phase. I really do appreciate your expertise. Excellent may not be enough.

    Regards,

    Neilesh

+ 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 with Unique Values bases on a criteria
    By Neilesh Kumar in forum Excel General
    Replies: 5
    Last Post: 03-24-2017, 06:22 AM
  2. Two Criteria Index Match on Multiple Sheets with Multiple Values
    By MegganM in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2016, 09:51 PM
  3. [SOLVED] Index/Match with Multiple Criteria and Multiple return values
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2015, 10:27 AM
  4. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  5. Replies: 0
    Last Post: 07-08-2014, 09:51 AM
  6. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  7. SOS:Return multiple values against multi criteria match and index function
    By nitesh_inin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-26-2012, 05:45 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