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[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Project #[/TD]
[TD]Total[/TD]
[TD]Week-ending Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]123[/TD]
[TD]$50[/TD]
[TD](V-lookup Formula)[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Project #[/TD]
[TD]Client[/TD]
[TD]Week-ending Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]123[/TD]
[TD]Carol[/TD]
[TD]9/16/2014[/TD]
[/TR]
</tbody>[/TABLE]
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[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Project #[/TD]
[TD]Total[/TD]
[TD]Week-ending Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]123[/TD]
[TD]$50[/TD]
[TD](V-lookup Formula)[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Project #[/TD]
[TD]Client[/TD]
[TD]Week-ending Date[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]123[/TD]
[TD]Carol[/TD]
[TD]9/16/2014[/TD]
[/TR]
</tbody>[/TABLE]