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
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Task 001
[/TD]
[TD]Task 002
[/TD]
[/TR]
[TR]
[TD]x001
[/TD]
[TD]Expected Outcome [3/30/14]
[/TD]
[TD]Expected Outcome 6/5/2014
[/TD]
[/TR]
[TR]
[TD]unique ID
[/TD]
[TD]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
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

Sheet 2

[TABLE="class: grid, width: 467, align: left"]
<TBODY>[TR]
[TD]ID</SPAN>
[/TD]
[TD]Task 001 Forecast</SPAN>
[/TD]
[TD]Task 001 Actual</SPAN>
[/TD]
[TD]Task 002 Forecast</SPAN>
[/TD]
[TD]Task 002 Actual</SPAN>
[/TD]
[/TR]
[TR]
[TD]X001</SPAN>
[/TD]
[TD="align: right"]05/05/2014</SPAN>
[/TD]
[TD="align: right"]03/30/2014</SPAN>
[/TD]
[TD="align: right"]06/05/2014</SPAN>
[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]



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