Vlook up with if statement

[Jools]

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

 

[Gary''s Student]

Something like:

=IF(VLOOKUP(B1,C14,2)<0,0,VLOOKUP(B1,C14,2))

 

[Jools]

Hi,

Thanks is all working ok now.

thanks
J

Something like:

=IF(VLOOKUP(B1,C14,2)<0,0,VLOOKUP(B1,C14,2))