Hi,

I need to do the following and have tried with a vlook up and nested if but
does not seem to be working.

I have two sheets and I need to look up a value on sheet 1 and return it to
sheet 2 however if the value is 0 I want to show the figure and if it is <
0 I need to return 0.

any ideas much appreciated

Thanks
J