Hi,

Am Fri, 9 Nov 2012 04:33:11 +0000 schrieb Excel Dumbo:

Please see attached file and kindly advise a formula to look up value
using 4 criterias.

in C3 try:

=INDEX(D$15:D$16,MATCH($A3&$B3&C$2,$A$15:$A$16&$C$ 15:$C$16&$B$15:$B$16,0))
and enter the array formula with CTRL+Shift+Enter and copy to right and
down.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2