Vlookup using two criteria -not working

[Excel Dumbo]

Hello,

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

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

Please help

Regards,
Dumb

+-------------------------------------------------------------------
|Filename: Lookup using two conditions.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=677
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Mon, 12 Nov 2012 08:43:43 +0000 schrieb Excel Dumbo:

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

in C3 try:
=INDEX('Look UP Data'!D$1$100,MATCH($B$2&$B3,'Look UP Data'!$C$1:$C$100&'Look UP Data'!$A$1:$A$100,0))
and enter the array formula with CTRL+Shift+Enter
Then copy the formula to right and down.


Regards
Claus Busch

 

[Excel Dumbo]

THanks a lot Claus. It worked

+-------------------------------------------------------------------
+-------------------------------------------------------------------