Look UP formula for 2 and 3 conditions

[Excel Dumbo]

Hello,

Could you please look in to the attached file and advise formula for th
two cases shown ?
I will need a formula to look up data matching multiple condtions.


Regards,
Dumb

+-------------------------------------------------------------------
|Filename: LookUP Query.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=830
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Tue, 2 Apr 2013 09:32:54 +0000 schrieb Excel Dumbo:

Could you please look in to the attached file and advise formula for the
two cases shown ?
I will need a formula to look up data matching multiple condtions.

for the first lookup try in B5:
=INDEX('LookUP data'!C$5:C$8,MATCH($B$3&$A5,'LookUP data'!$A$5:$A$8&'LookUP data'!$B$5:$B$8,0))
and enter the array formula with CTRL+Shift+Enter
and copy down and to the right.

for the second lookup try in C13:
=INDEX('LookUP data'!$A$14:$M$17,MATCH($A13,'LookUP data'!$A$14:$A$17,0),MATCH(C$12,LEFT('LookUP data'!$A$14:$M$14,3),0))
and enter the array formula with CTRL+Shift+Enter and copy down and to
the right


Regards
Claus Busch