#N/A ERROR

[Guest]

I have the following following formula looking at a table. If G$9 does not
appear on the table I get the #N/A error message. How can I get it to return
zero instead?


=INDEX('ARG - EURO'!$A$6:$U$9, MATCH($C12,'ARG - EURO'!$A$6:$A$9,),
MATCH(G$9,'ARG - EURO'!$A$6:$U$6,))*$D$1

Thank you for your help,

Esther

 

[Bob Phillips]

Hi Esther,

You could try

=IF(ISNA(MATCH(G$9,'ARG - EURO'!$A$6:$U$6,)),0,INDEX('ARG - EURO'!$A$6:$U$9,
MATCH($C12,'ARG - EURO'!$A$6:$A$9,), MATCH(G$9,'ARG -
EURO'!$A$6:$U$6,))*$D$1)


--

HTH

RP
(remove nothere from the email address if mailing direct)