| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Look up with multiple variables
Hello Excel gurus,
this may sound simple to you. Could you please help me to find a formula to look up values using two variables as shown in the attached spreadsheet ? Thanks Excel Dumbo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up with multiple variables
Hi,
Am Tue, 31 Jul 2012 07:37:48 +0000 schrieb Excel Dumbo: this may sound simple to you. Could you please help me to find a formula to look up values using two variables as shown in the attached spreadsheet ? try in E2: =INDEX($J$4:$J$16,MATCH(A2&C2,$H$4:$H$16&$I$4:$I$1 6,0)) and enter the array formula with CRTL+Shift+Enter Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set Multiple Variables | Excel Programming | |||
| look up by multiple variables | Excel Discussion (Misc queries) | |||
| Multiple Variables | Excel Programming | |||
| how can i count multiple variables in multiple columns? | Excel Programming | |||
| Multiple variables-SOS | Excel Worksheet Functions | |||
Linear Mode
