Vlook up with if statement

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top