If(iserror 2003

[sburkhar]

I'm using the IF(ISERROR that you gave me which is working, but I need to multiply it by another cell. Here's what I did:

IF(ISERROR(VLOOKUP('MAT PAGE'!F26,'[VLOOKUP.xls]0-39999'!$B:$J,9,FALSE)),"",VLOOKUP('MAT PAGE'!F26,'[VLOOKUP.xls]0-39999'!$B:$J,9,FALSE))*C20

Obviously this is not the correct way to multiply because it's returning #VALUE! in the unoccupied cells. I need the unused cells to remain blank until needed so the calculations will work

 

[VoG]

Try

IF(ISERROR(VLOOKUP('MAT PAGE'!F26,'[VLOOKUP.xls]0-39999'!$B:$J,9,FALSE)),"",VLOOKUP('MAT PAGE'!F26,'[VLOOKUP.xls]0-39999'!$B:$J,9,FALSE)*C20)

 

[sburkhar]

crap. I tried this but forgot to remove one of the parenthesis before the multiple. Thank you for clarifying it for me.