Vlookup using two criteria -not working
 

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.

Please help

Regards,
Dumbo

Vlookup using two criteria -not working
 

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

THanks a lot Claus. It worked.