Vlookup referencing blank date cell to return blank instead of 01/00/00

[pup33pawz]

Hello,

Can someone help me with the V-lookup formula for this action?

I would like to auto-fill Sheet 1 C2 with the date from Sheet 2 C2. I would also like to copy the formula down and if there is no date in Sheet 2 C2 then Sheet 1 C2 would be blank. Right now my formula: =IFERROR(VLOOKUP($A2,Sheet2!$A$2:$C$2,3,0),"") is returning with "01/00/00" when there is no date in Sheet 2.

Sheet 1

	A	B	C
1	Project #	Total	Week-ending Date
2	123	$50	(V-lookup Formula)

<tbody>
</tbody>

Sheet 2

	A	B	C
1	Project #	Client	Week-ending Date
2	123	Carol	9/16/2014

<tbody>
</tbody>

 

[BobUmlas]

Format column C as
m/d/yyyy;;
(include the semicolons)

 

[pup33pawz]

Thank you BobUmlas. How do I format the date to where I can type the ;;? I've used the Number drop down tool and changed the format of Sheet1 column C to short date.

 

[pup33pawz]

Nevermind, I got it. Thank you!!