HELP!!! Vlookup and IF statement

[1of5kites]

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

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

 

[billszysz]

Hi,

Try

=IF(ISNUMBER(VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$C,3,0)),VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$C,3,0),vlookp(A2,[Sheet2.xlsx]Sheet1!$A:$B,2,0))

 

[1of5kites]

C2 had to be adjusted

C2=IF(ISNUMBER(VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$E,5,0)),VLOOKUP(A2,[Sheet2.xlsx]Sheet1!$A:$E,5,0),vlookp([Sheet2.xlsx]Sheet1!$A:$D,4,0))

But i understand the formula thank you:

 

[billszysz]

Thanks for your feedback