Originally Posted by Claus Busch

Hi,

Am Thu, 21 Nov 2013 08:46:35 +0000 schrieb eltyar:

just one more thing i need to put "0" if any value in the function not
found.

if you use xl2007 or later:
=IFERROR(INDEX($I$1:$M$6,MATCH(A3,$I$1:$I$6,0),MAT CH(B3,$I$2:$M$2,0)),0)
for earlier versions try:
If(Iserror(YourFormula);0;YourFormula)


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