Results 1 to 9 of 9

Index-Match function with multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Boulder, Colorado
    MS-Off Ver
    2016
    Posts
    45

    Index-Match function with multiple criteria

    So I'm trying to create an index/match function that will input data into one sheet referencing the data in another. I want it to input the offer number into the PO sheet for the Purchase order it matches according to: Customer name,Product type, and project $ amount. The offer number should be inputted in the "Offer #" column. For some reason my index/match formula is returning with a "too many arguments" error. The way I understand the index function and the formula I have been trying is:

    =INDEX(Offers!B2:D24,match(Pos!B2,Offers!B2:B24,0,match(Pos!C2,Offers!C2:C24,0,match(Pos!D2,Offers!D2:D24,0),1

    I'm sure theres something wrong with the way I'm setting this up but I honestly have no idea what that could be since I've been trying everything. Any help would be greatly appreciated.
    I'll upload a sample file to show what I'm talking about.
    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. How do you drag down an index match function with multiple criteria?
    By larryg003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2014, 01:26 PM
  2. Using MATCH and INDEX function with multiple criteria
    By Babylon in forum Excel Programming / VBA / Macros
    Replies: 52
    Last Post: 02-06-2014, 11:28 AM
  3. Multiple Criteria Index/Match Function in VBA Looking Up Dates/Strings/Numbers
    By nadstradamus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 12:35 PM
  4. Index and match function multiple criteria
    By mfortier3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2013, 05:27 AM
  5. 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