return a value depending on two previous values
 

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!

return a value depending on two previous values
 

Hi,

Am Wed, 21 Nov 2012 02:15:47 +0000 schrieb petschek:

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.

try:
=INDEX(J5:M8,MATCH(A6,$J$5:$J$8,0),MATCH(E6,$J$5:$ M$5,0))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2