Excel - IF Statement: You've entered too many arguments.

[mdro]

Hello,

I am working on a spreadsheet that allocates costs based on information pulled from a pivot table.

The spreadsheet matches the userID and product symbol from the target worksheet with the related cost found in the pivot table.

The formula I have in place is: =INDEX('JAN08-PT'!$B$5:$AO$103,MATCH($A15,'JAN08-PT'!$A$5:$A$102,),MATCH(G$4,'JAN08-PT'!$B$4:$AN$4,))

The formula works but there are instances where a user does not have any activity from one month to the next. When that happens, I get a #REF result in the target cell.

I'd like to add in the argument IF(ISREF) change the result to a "0" or nothing at all but I come up with a too many arguments error.

Any idea how I can get around this?

Thanks in advance for any input you may have!

MD

 

[ck1999]

have you looked at iserror


if (iserror(=INDEX('JAN08-PT'!$B$5:$AO$103,MATCH($A15,'JAN08-PT'!$A$5:$A$102,),MATCH(G$4,'JAN08-PT'!$B$4:$AN$4,)),"",=INDEX('JAN08-PT'!$B$5:$AO$103,MATCH($A15,'JAN08-PT'!$A$5:$A$102,),MATCH(G$4,'JAN08-PT'!$B$4:$AN$4,)))



ck1999

 

[mdro]

Thanks for the feedback ck1999. Unfortunately, i still get the same error: too many arguments. Any other ideas?

 

[ck1999]

try

if (iserror(INDEX('JAN08-PT'!$B$5:$AO$103,MATCH($A15,'JAN08-PT'!$A$5:$A$102,),MATCH(G$4,'JAN08-PT'!$B$4:$AN$4,))),"",INDEX('JAN08-PT'!$B$5:$AO$103,MATCH($A15,'JAN08-PT'!$A$5:$A$102,),MATCH(G$4,'JAN08-PT'!$B$4:$AN$4,)))


ck1999

 

[mdro]

Negative. Same issue.

 

[ck1999]

Did you copy and paste? I added 1 )

It accepted the formula for me. Except wanting to look up the name

ck1999

 

[mdro]

My apologies; it does work!

Thank you so much! You're a saint.

 

[SkipVought]

mdro,

If ck1999's post was helpful, then it is not only customary but also beneficial to...
[blue]
Thank ck1999
for this valuable post!
[/blue]
It's good manners AND it helps to identify post containing good, helpful information, for other members searching for anwsers.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}