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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2