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!!

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

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.

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

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

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!