| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a value from Chart 1 depending on the value typed into char | Excel Worksheet Functions | |||
| Color cell depending on it's previous value | Excel Programming | |||
| Return a value, depending on particular day Q | Excel Worksheet Functions | |||
| LOOKUP return the value from the previous row | Excel Worksheet Functions | |||
| Return A, B, C, or D depending on percentage | Excel Worksheet Functions | |||
Threaded Mode
