ExcelBanter - Look up with multiple variables

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Look up with multiple variables (https://www.excelbanter.com/excel-discussion-misc-queries/446723-look-up-multiple-variables.html)

Excel Dumbo

Look up with multiple variables

1 Attachment(s)

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

Claus Busch

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

All times are GMT +1. The time now is 06:30 AM.