return a value depending on two previous values

[petschek]

Hi all,

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

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

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


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

+-------------------------------------------------------------------
|Filename: example translator log.xlsx.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=694
+-------------------------------------------------------------------

 

[Claus Busch]

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