+ Reply to Thread
Results 1 to 2 of 2

Index, Match to a range of values < >

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    N/A
    MS-Off Ver
    MS 365
    Posts
    70

    Exclamation Index, Match to a range of values < >

    Hello

    currently I have an index/match formula pulling the % from a table. However, I want to build a range into this formula and despite a few attempts - I can't quite manage it..

    1>1.99 2>2.99 3>4 (scores)
    Employee 0% 1% 3%
    Employee1 0% 1% 5%
    Employee2 0% 2% 8%
    Employee3 0% 2.50% 1%
    Employee4 0% 1.50% 5%

    For example, Employee2 achieved a score of 2.79, from the table above this would equate to the percentage value of 2%. I would like to write a formula which will pull the corresponding % value from the table based on score within the range.
    At the moment I am using an index/match but it will only pick up an absolute values, not the range

    I can't figure out how to tackle it..

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Index, Match to a range of values < >

    I'm not following. Can you put it into a spreadsheet showing what you have and results expected, several examples
    (Go Advanced>Manage Attachments)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. Formula to Index, Match, Rank, and Sort a Dynamic Range of Values
    By AustinLe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2014, 03:49 AM
  2. Index match offset to get subsequent index values in a column
    By Andrew_Step in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 02:55 PM
  3. [SOLVED] INDEX MATCH - Selecting lowest value in a range of values
    By indyrob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-23-2013, 04:36 AM
  4. Replies: 17
    Last Post: 12-05-2012, 09:01 PM
  5. VBA - Index double match and insert values in range
    By Biinge in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2011, 02:43 PM

Tags for this Thread

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