+ Reply to Thread
Results 1 to 3 of 3

How to return a value from a table based on multiple criteria

  1. #1
    Registered User
    Join Date
    02-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    How to return a value from a table based on multiple criteria

    Hi,

    I'm sure there is a simple solution but I've been reading forums and trying to find a solution but have hit a brick wall.

    I want to return the target rate / salary range for a series of employees based on their role and level. I've attached a sample of my spreadsheet and removed any sensitive data.

    Any info would be greatly appreciated - i've tried VLOOKUPs, INDEX MATCH etc but am obviously missing something!

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.91 for Mac MS 365
    Posts
    8,607

    Re: How to return a value from a table based on multiple criteria

    this looks like it may work for you, it appears to have worked in your test sheet…
    =INDEX('Salary Range'!$B$2:$F$6,MATCH([@Level],'Salary Range'!$A$2:$A$6,0),MATCH([@Role],'Salary Range'!$B$1:$F$1,0))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    02-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: How to return a value from a table based on multiple criteria

    That worked - thanks so much for that

    I have no idea what I did the first time around when trying the Index Match formula but it wasn't that... but it makes perfect sense now!

+ 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. [SOLVED] Return a Value in a Table based upon certain criteria
    By Staci in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2014, 08:02 PM
  2. Replies: 5
    Last Post: 06-21-2012, 10:36 AM
  3. Replies: 6
    Last Post: 05-21-2012, 11:51 PM
  4. Return a value from a multiple criteria table
    By cktung in forum Excel General
    Replies: 6
    Last Post: 12-26-2011, 03:39 AM
  5. Return values from table based on 2 criteria
    By BCjohnstone in forum Excel General
    Replies: 1
    Last Post: 08-30-2006, 09:37 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