#N/A ERROR
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
|