VLOOKUP 00-Jan-00

T

tufailjpn

hi all,
below is my vlookup formula, but when data base doesn't have date value
00-Jan-00 is coming out, which is really effecting my other formula which is
related cell $AW9, any solution ?

=IF($AW9="","",IF(ISNA(VLOOKUP($AW9,ShipD,5,)),"",VLOOKUP($AW9,ShipD,5,)))
 
G

Gary''s Student

This can be easily fixed. What would you like to see if data base doesn't
have date value ??
 
D

Dave Peterson

Add another check:

=if($aw9="","",if(isna(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))))

Or since you're showing "" for all "errors"
=if($a2="","",if(iserror(1/len(vlookup(...))),"",vlookup(...)))
or
=if(iserror(1/len(vlookup(...))),"",vlookup(...))

xl2007 adds an =iferror() that may make it even simpler.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank 3
SUMPRODUCT 2
SUMPRODUCT 00-Jan-00 6
Average formula multiple worksheets 1
confused about date format 8
Blank dates showing as 00 january 1900 - help 3
What am I doing wrong 14
Need Help with VLOOKUP 4

Top