Look up with multiple variables

E

Excel Dumbo

Hello Excel gurus,

this may sound simple to you. Could you please help me to find a formul
to look up values using two variables as shown in the attache
spreadsheet ?


Thanks
Excel Dumb

+-------------------------------------------------------------------
|Filename: Look UP using multiple variable.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=516
+-------------------------------------------------------------------
 
C

Claus Busch

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 ?
Click to expand...

try in E2:
=INDEX($J$4:$J$16,MATCH(A2&C2,$H$4:$H$16&$I$4:$I$16,0))
and enter the array formula with CRTL+Shift+Enter


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look UP formula for 2 and 3 conditions 1
Separate Values 3
Look UP using 4 criterias 2
V Look up with drop down functionality 5
Look UP and then caluclation with IS ERROR 3
Vlookup using two criteria -not working 2
Help with Look Up with multiple complex conditions 2
Complicated Look Up (without making changes to the blank spaces in the table) 2

Top