I have an issue that I cannot figure out. hopefully this description makes sense:
This isnt working =IF(VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$C,3,0)>0,VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$C,3,0),vlookp(A2,[Sheet2.xlsx]Sheet1!$A:$B,2,0))
Sheet 1
<TBODY>
</TBODY>
Sheet 2
<TBODY>
</TBODY>
Thanks,
John
This isnt working =IF(VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$C,3,0)>0,VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$C,3,0),vlookp(A2,[Sheet2.xlsx]Sheet1!$A:$B,2,0))
Sheet 1
ID | Task 001 | Task 002 |
x001 | Expected Outcome [3/30/14] | Expected Outcome 6/5/2014 |
unique ID | If there is an actual date for task 001 in sheet 2 then this field would have the actual date. If there is no actual date then it would return the forecasted date for Task 001 |
<TBODY>
</TBODY>
Sheet 2
ID</SPAN> | Task 001 Forecast</SPAN> | Task 001 Actual</SPAN> | Task 002 Forecast</SPAN> | Task 002 Actual</SPAN> |
X001</SPAN> | 05/05/2014</SPAN> | 03/30/2014</SPAN> | 06/05/2014</SPAN> |
<TBODY>
</TBODY>
Thanks,
John