Results 1 to 12 of 12

Index Match with Two Criteria, Mix of Multiple Correct Rows and Greater than Rows

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2016
    Location
    Wiltshire
    MS-Off Ver
    2010
    Posts
    7

    Post Index Match with Two Criteria, Mix of Multiple Correct Rows and Greater than Rows

    Need help getting correct answer for the following-
    I have three columns of data:
    Column A shows several answers, multiple times
    Column B shows ascending numbers for each of the different answers in Column A
    Column C is the data I wish to return.

    I wish to get the correct answer from Column C (or the answer that is less than the match), corresponding to the correct part of column B as identified by column A.
    Example attached should make this clearer.

    I have tried all forms of index, match and if statements, but this is beyond me as keeps throwing up the wrong answer. I can set the data table up differently if this would help.

    Appreciate anyone's help with this.

    thanks
    Attached Files Attached Files
    Last edited by hochpoch; 01-31-2016 at 05:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 10-26-2021, 05:36 AM
  2. Help with index match with multiple rows criteria
    By parreich in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2015, 02:52 AM
  3. Replace Index Match with VBA - Multiple Criteria - Thousands of rows and columns
    By jaybrd1 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-30-2014, 08:39 AM
  4. VLookup or Index/match searching rows instead of columns or multiple criteria
    By Groovicles in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-16-2013, 05:00 PM
  5. [SOLVED] Index/Match - multiple criteria & greater than!
    By kennedy.clan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2013, 09:03 AM
  6. [SOLVED] INDEX+MATCH with multiple criteria across both rows and columns
    By george_k in forum Excel General
    Replies: 3
    Last Post: 10-26-2012, 04:11 PM
  7. [SOLVED] Index and Match Multiple Header (Rows) Criteria
    By dluhut in forum Excel General
    Replies: 7
    Last Post: 04-12-2012, 06:25 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