Results 1 to 6 of 6

VLOOKUP - Suppressing blank dates

Threaded View

JohnPWilliams VLOOKUP - Suppressing blank... 08-16-2010, 10:38 AM
NBVC Re: VLOOKUP - Suppressing... 08-16-2010, 10:42 AM
DonkeyOte Re: VLOOKUP - Suppressing... 08-16-2010, 10:55 AM
JohnPWilliams Re: VLOOKUP - Suppressing... 08-17-2010, 08:36 AM
JohnPWilliams Re: VLOOKUP - Suppressing... 08-16-2010, 11:01 AM
JohnPWilliams Re: VLOOKUP - Suppressing... 08-18-2010, 10:36 AM
  1. #1
    Registered User
    Join Date
    09-05-2007
    Posts
    19

    VLOOKUP - Suppressing blank dates

    Hello,

    I'm trying to get to grips with VLOOKUP but struggling a bit so would appreciate some help. I'm trying to pull through some dates from a worksheet and tag them onto the end of a table. Here's a sample of the formula - =VLOOKUP($A4, Sheet2!$A3:$H40,3). Cell A4 contains a key which is being used to locate the corresponding dates. The formula works fine and pulls through the dates, so fine up to there...

    However, when a user has not entered a date it returns "00 January 1900". Is there a way of making Excel suppress the date if it's either blank or equal to the above (whichever is easier)? Unfortunately, the users will not always know the date so I will have to handle the NULLs somehow...!

    Any help would be appreciated - hope the above is clear.

    Cheers - John.
    Last edited by NBVC; 08-17-2010 at 10:06 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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