Something like:

=IF(VLOOKUP(B1,C1:D4,2)<0,0,VLOOKUP(B1,C1:D4,2))

--
Gary''s Student - gsnu200851


"Jools" wrote:

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