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