To many arguments when using If(ISERROR)

[LeapingLizard]

Hello,

I get a #N/A error when using this formula.

=INDEX(LookupLists!$D$2:$D$55,MATCH(LinenData!C2,LookupLists!$B$2:$B$55,0))*E2

In order to eliminate this error from displaying I have tried this

=If(ISERROR(INDEX(LookupLists!$D$2:$D$55,MATCH(LinenData!C2,LookupLists!$B$2:$B$55,0))*E2,0,=INDEX(LookupLists!$D$2:$D$55,MATCH(LinenData!C2,LookupLists!$B$2:$B$55,0))*E2)

I get a too many arguments error with this. What can I do to eliminate this error message #n/A.

Thanks,

LeapingLizard

[daffodil11]

If you have Excel 2010 as written in your profile, you could use IFERROR instead.

=IFERROR(INDEX(LookupLists!$D$2:$D$55,MATCH(LinenData!C2,LookupLists!$B$2:$B$55,0))*E2,0)

Or you could take out the "=" floating in the middle of your formula to make ISERROR work.

[sourabhg98]

Why dont you use an iferror formula
=iferror(INDEX(LookupLists!$D$2:$D$55,MATCH(LinenData!C2,LookupLists!$B$2:$B$55,0))*E2,"")

Hope it helps

If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

Regards
Sourabh Gupta

[romperstomper]

You'd also need another parenthesis after the first *E2.

[Richard Buttrey]

Hi,

Does the C2 value appear in B2:B55?

Perhaps you'd better uploading the workbook.