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
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
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>