Results 1 to 7 of 7

Index & Match Formula for Unique Values On Multiple Criteria

Threaded View

  1. #3
    Registered User
    Join Date
    04-05-2018
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    11

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

    Thank you! I've attached the worksheet, and cut out all of the identifying information. I added three "desired results" tabs, for the three different vendors, and I left the formulas that work intact.

    Essentially, on the Memo Creator tab, the only two fields that should be manipulated are B17 (a drop down LOVs) and N9.

    When you choose 123 Company, I only want two out of the three invoices listed on the Masters Invoice Entry tab to appear. The ones that match 123 company and are for the month of March. I do NOT want the April 2018 invoice to appear.

    Hope this makes sense.

    Thank you!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looking for help on unique value pull with multiple criteria using Index Match
    By shinobi2u in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2017, 05:07 PM
  2. [SOLVED] Index & Match Formula for Unique Values On Multiple Criteria
    By Neilesh Kumar in forum Excel General
    Replies: 2
    Last Post: 03-24-2017, 10:13 AM
  3. [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
  4. 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
  5. [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
  6. Replies: 0
    Last Post: 07-08-2014, 09:51 AM
  7. [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

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