Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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 |
#2
|
|||
|
|||
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) "EstherJ" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Findlink Error | Links and Linking in Excel | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) | |||
How to set Error Bars to _two_ SDs? | Charts and Charting in Excel | |||
#REF error | Excel Worksheet Functions |