1. ## How to add IS Error in formula (2000 sp3)

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,

2. ## Re: How to add IS Error in formula (2000 sp3)

=IF(OR(ISNA(VLOOKUP(W2,Calendar!\$A\$1:\$C\$3489,3)),I SNA(VLOOKUP(F2,Calendar!\$A\$1:\$C\$3489,3))),"",VLOOK UP(W2,Calendar!\$A\$1:\$C\$3489,3)-VLOOKUP(F2,Calendar!\$A\$1:\$C\$3489,3))

3. ## Re: How to add IS Error in formula (2000 sp3)

Does this do what you want?

<code>
=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)))
</code>

4. ## Re: How to add IS Error in formula (2000 sp3)

All,
Both work great!

Thanks,

5. ## Re: How to add IS Error in formula (2000 sp3)

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?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•