# Nested If Statement - ISNA issue

1. ## Nested If Statement - ISNA issue

For some reason I'm drawing a blank (mental blank). Trying to resolve my #N/A issue and normally I firgure it out, but alas, I'm slightly brain dead this morning.

Current formula: =IF(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)<IN!\$B\$2,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)+365,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE))

Any help would be greatly appreciated. Maybe more coffee will hep this morning!!

2. ## Re: Nested If Statement - ISNA issue

This is probably because your 1st vlookup cannot find what you are looking for. Wrap the entire thing in ISERROR()

3. ## Re: Nested If Statement - ISNA issue

Try it like this:

=IF(ISNA(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)),"error message", your_exisiting_formula )

Don't forget the bracket at the end.

Hope this helps.

Pete

4. ## Re: Nested If Statement - ISNA issue

I'm writing it like so :=IF(ISNA(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)<IN!\$B\$2,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)+365,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)),"",VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)<IN!\$B\$2,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)+365,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE))

However, it's not liking the +365 which is part of my original If statement so.... issue in the head.

5. ## Re: Nested If Statement - ISNA issue

FD, I get a return of FALSE when I do this.

6. ## Re: Nested If Statement - ISNA issue

Originally Posted by Bearack
I'm writing it like so ...
That is not what I suggested. Try it like this:

=IF(ISNA(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)),"error message", IF(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)<IN!\$B\$2,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)+365,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)))

Change "error message" for what you want to see if there is no exact match.

Hope this helps.

Pete

7. ## Re: Nested If Statement - ISNA issue

Originally Posted by Pete_UK
That is not what I suggested. Try it like this:

=IF(ISNA(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)),"error message", IF(VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)<IN!\$B\$2,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)+365,VLOOKUP(A4,'MW Schedule'!P:AQ,28,FALSE)))

Change "error message" for what you want to see if there is no exact match.

Hope this helps.

Pete
Nailed it, thanks you... I see my error in not continueing my IF statement on the secodn half of the ISNA chain. Thanks a mint!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1