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

**Tafflisa** · 11-30-2014, 08:11 AM

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

**Sam Capricci** · 11-30-2014, 08:35 AM

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))

**Tafflisa** · 11-30-2014, 03:05 PM

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!

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return a Value in a Table based upon certain criteria

how to search multiple col/row table wit multiple criteria to return lowest value

[SOLVED] Need to return value from one table based on 2 different criteria from another

Return a value from a multiple criteria table

Return values from table based on 2 criteria

Bookmarks

Bookmarks

Posting Permissions