How to add IS Error in formula (2000 sp3)

Topic

New Reply

Greetings!
I have the following formula =(VLOOKUP(W2,Calendar!$A$1:$C$3489,3))-(VLOOKUP(F2,Calendar!$A$1:$C$3489,3))
How do I use the ISERROR so that it will not show #N/A ?

Thanks,
Brad

Reply | Quote

Replies

=IF(OR(ISNA(VLOOKUP(W2,Calendar!$A$1:$C$3489,3)),ISNA(VLOOKUP(F2,Calendar!$A$1:$C$3489,3))),””,VLOOKUP(W2,Calendar!$A$1:$C$3489,3)-VLOOKUP(F2,Calendar!$A$1:$C$3489,3))

Reply | Quote

Does this do what you want?


=IF(OR((ISERROR(VLOOKUP(W2,Calendar!$A$1:$C$3489,3))),ISERROR((VLOOKUP(F2,Calendar!$A$1:$C$3489,3)))),"",(VLOOKUP(W2,Calendar!$A$1:$C$3489,3))-(VLOOKUP(F2,Calendar!$A$1:$C$3489,3)))


Reply | Quote

All,
Both work great!

Thanks,
Brad

Reply | Quote

Given your formula, #N/A can only occur when either W2 or F2 is smaller/less than Calendar!$A$1.

If Calendar!$A$1:$C$3489 is sorted in ascending order on its first column, a state of affairs that justifies your setup for the VLOOKUP bits (No 4th arg, meaning 1 or TRUE), you don’t need ISERROR()…

Care to indicate what kind of stuff you have in Calendar!$A$1:$A$3489?

Reply | Quote