Sigmaz

Posts: n/a

IF ISNA HELP, please..I cant add #N/A but 0 is another story

Can anyone please help me wrap this formula with an IF ISNA function so that
the result returns a 0 instead of #N/A when values aren't available to
satisfy the match.

=INDEX(EXPORTSUMMARY!C2:C60,MATCH(1,(EXPORTSUMMARY !A2:A60=2)*(EXPORTSUMMARY!B2:B60=1),0))

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
ISNA and VLOOKUP	Chris Kellock	Excel Worksheet Functions	3	March 12th 05 07:05 AM
if isna and vlookup together	tina	Excel Worksheet Functions	2	January 20th 05 01:06 PM
ISNA question	ShineboxNJ	Excel Worksheet Functions	2	January 6th 05 10:49 PM

All times are GMT +1. The time now is 11:20 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us