Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 190
Default blank date shows up as s 1/0/00

I am doing a vlookup on a worksheet that shows a blank date in the field yet
on the vlookup it shows as 1/0/00. How can I correct this.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default blank date shows up as s 1/0/00

You seem to have the formula cell formatted as DATE so I'm assuming that
you're expecting a date result and 0 is not a possible result of the
formula.

Try something like this:

=IF(your_vlookup_formula_here=0,"",your_vlookup_fo rmula_here)

--
Biff
Microsoft Excel MVP


"Mary" wrote in message
...
I am doing a vlookup on a worksheet that shows a blank date in the field
yet
on the vlookup it shows as 1/0/00. How can I correct this.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default blank date shows up as s 1/0/00

Trap for it in your formula

=IF(VLOOKUP(G1,$A$1:$F$31,2,FALSE)="","",(VLOOKUP( G1,$A$1:$F$31,2,FALSE)))


Gord Dibben MS Excel MVP

On Wed, 16 Jul 2008 13:43:01 -0700, Mary wrote:

I am doing a vlookup on a worksheet that shows a blank date in the field yet
on the vlookup it shows as 1/0/00. How can I correct this.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shows blank worksheet but ok in print preview Big Mac Excel Discussion (Misc queries) 1 November 14th 06 03:36 PM
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 09:40 PM
My Excel 2000 shows 97 worksheets grey-blank - help!? MG-Trophy Excel Discussion (Misc queries) 2 December 21st 05 01:30 AM
Date shows as 01/01/00 Kmagg Excel Discussion (Misc queries) 2 September 23rd 05 11:51 PM
blank data field shows quote in formula, how to delete it? wdanner Excel Discussion (Misc queries) 2 April 4th 05 08:44 PM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"