(Msg. 1) Posted: Tue Jun 09, 2009 3:16 pm
Post subject: Vlookup Archived from groups: microsoft>public>excel>newusers (more info?)
Hi I'm using this lookup to find a date from another tab but I would like
it to leave it blank if there is not a date instead of filling in 1/0/1900?
Does anyone know a way to fix this? Thank you!!
(Msg. 2) Posted: Tue Jun 09, 2009 4:00 pm
Post subject: Re: Vlookup [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
As the "1/0/1900" is a zero, indicatively,
you could try it like this:
=IF(VLOOKUP(...)=0,"",VLOOKUP(...))
which will return "blanks" ie: "" (zero length null strings)
where the vlook evaluates to zeros
Success? High-five it, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"H" wrote:
> Hi I'm using this lookup to find a date from another tab but I would like
> it to leave it blank if there is not a date instead of filling in 1/0/1900?
> Does anyone know a way to fix this? Thank you!!
>
> =VLOOKUP(B4,'Data'!A2:F7863,3,FALSE)
(Msg. 3) Posted: Tue Jun 09, 2009 10:50 pm
Post subject: RE: Vlookup [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
You could apply the following format where the VLOOKUP formula is without
needing to modify your formula:
m/d/yyyy;;
Create this format by choosing Format, Cells, Number tab, Custom and
entering it on the Type line.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"H" wrote:
> Hi I'm using this lookup to find a date from another tab but I would like
> it to leave it blank if there is not a date instead of filling in 1/0/1900?
> Does anyone know a way to fix this? Thank you!!
>
> =VLOOKUP(B4,'Data'!A2:F7863,3,FALSE)
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
I'm using this lookup to find a date from another tab but I would like
Office