J
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
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