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