Results 1 to 5 of 5

INDEX MATCH Multiple Criteria across two sheets will not work

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2017
    Location
    Beaumont, Alberta
    MS-Off Ver
    2013
    Posts
    15

    INDEX MATCH Multiple Criteria across two sheets will not work

    Hi All,
    I'm becoming beyond frustrated. I have a small input section on 1 page where the user is able to select two criteria (the second list being limited by a selection made in the first). Once those selections are made, there are two other cells that should automatically return a value from a table in a different page. I have tried every possible method I could google, without luck. (Everything indicates an array formula however, still not working)
    I'm beginning to think, at this point, it may be something to do with the initial values that are selected(?). As these are mapped directly from the table however, there may be some rounding taking place that could become the cause for a value to not pass the exact match criteria. They are calculated values.

    Please see attachment to see if there is any sense to be made...

    Anything you could provide would be extremely appreciated.

    Thanks and Regards!,

    DHT Tech

    ***Cross posted: https://www.mrexcel.com/forum/excel-...post4994396***
    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. Index Match multiple criteria wont work, but nested IF's do-partially
    By andrewoz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2016, 02:12 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. Replies: 5
    Last Post: 02-06-2015, 08:44 PM
  4. [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
  5. Vlookup (or index/match) with multiple criteria over multiple sheets
    By Groovicles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 01:56 PM
  6. Index and Match across multiple work sheets.
    By violinm in forum Excel General
    Replies: 1
    Last Post: 06-15-2011, 03:42 AM
  7. Replies: 0
    Last Post: 06-14-2011, 02:21 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