Multiple criteria selections

**petschek** · 11-20-2012, 09:54 PM

Hi all,

I have three different people providing a service (translations). Each person has three different rates depending on the type of translation (normal, rushed, and other). I have to keep a log of all the translations.

I would like to be able to put in the translators name and the type of translation and have a formula return what that persons rate is for the type of translation.

I have attempted to use "=index(match(" but have not been able to get it to work with how my data is set up.

Attached is a sample of what I am trying to do, any and all help is greatly appreciated!

**Moo the Dog** · 11-20-2012, 10:09 PM

Try this:

Formula:

Please Login or Register  to view this content.

You could also use:

Formula:

Please Login or Register  to view this content.

- Moo

**davesexcel** · 11-20-2012, 10:17 PM

This should work
=INDEX(K6:M8,MATCH(A6,$J$6:$J$8,0),MATCH(E6,$K$5:$M$5,0))

Check out index-match formula
http://www.davesexcel.com/howtouseindexmatch.htm