IF and LOOKUP formula help

[flocku2]

This is my formula, The LOOKUP formula alone works except that I need it to return a "ZERO" if D44<0.

=IF(D44>0,LOOKUP(PRIORITY!D:D,'finish sched'!AK:AK,'finish sched'!AM:AM,0))

Thank you

[flocku2]

I figured it out, Thank you everyone who looked at this
=IF(D44>0,LOOKUP(PRIORITY!D:D,'finish sched'!AK:AK,'finish sched'!AM:AM,0))
just had to move the parenthesis.
=IF(D44>0,LOOKUP(PRIORITY!D:D,'finish sched'!AK:AK,'finish sched'!AM:AM),0)