lookup with two criteria not working [SOLVED]

[Ecel Dumbo]

Hello,


Could you please refer the attached worksheet and kindly suggest a formula to look up values using two criterias.


I used index, match functions and they dont seem to work.


Link to the file is


http://speedy.sh/Pcamn/Lookup-using-two-conditions.xls


Please help


Regards,

Dumbo

 

[Faseeh]

Hi Ecel Dumbo,


With reference to your sheet you can use this formula:

=SUMPRODUCT(('Look UP Data'!$A$3:$A$92=Result!$B3)*('Look UP Data'!$C$3:$C$92=Result!$B$2)*('Look UP Data'!$D$2:$F$2=Result!C$1)*('Look UP Data'!$D$3:$F$92))

Regards,

Faseeh

 

[sdsurzh]

Hi,


Can you please try the below formula.


For Jan =INDEX('Look UP Data'!$D$5:$D$92,MATCH(Result!$B2,'Look UP Data'!$C$5:$C$92,0),MATCH(Result!$B3,'Look UP Data'!$A$5:$A$92,0))


For Feb =INDEX('Look UP Data'!$E$5:$E$92,MATCH(Result!$B2,'Look UP Data'!$C$5:$C$92,0),MATCH(Result!$B3,'Look UP Data'!$A$5:$A$92,0))


For Mar =INDEX('Look UP Data'!$F$5:$F$92,MATCH(Result!$B2,'Look UP Data'!$C$5:$C$92,0),MATCH(Result!$B3,'Look UP Data'!$A$5:$A$92,0))


Thanks,

Suresh Kumar S

 

[Ecel Dumbo]

THank you suresh and faseeh. it worked. thanks so much