EstherJ

Posts: n/a

#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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Findlink Error	D Moniz via OfficeKB.com	Links and Linking in Excel	0	January 20th 05 04:53 PM
Error when entering and exiting excel	Randy	Excel Discussion (Misc queries)	1	January 11th 05 03:17 PM
Downloading Templates for Excel error with a windows error.	Lanie Moore	Excel Discussion (Misc queries)	0	December 20th 04 11:39 PM
How to set Error Bars to _two_ SDs?	[email protected]	Charts and Charting in Excel	1	December 7th 04 02:00 AM
#REF error	Christen	Excel Worksheet Functions	5	November 3rd 04 07:29 PM

All times are GMT +1. The time now is 10:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us