Thread: #N/A ERROR
View Single Post
  #1   Report Post  
EstherJ
 
Posts: n/a
Default #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