Hi,
I'm trying to look up a value if a cell is greater than 0.
if the cell is 0 or less I want the formula to return $0.00.
=IF(C4>0,HLOOKUP(B4,Sheet3!B5:D10,3,FALSE))
I attached the spreadsheet as well.
Thank you,
PS
Hi,
I'm trying to look up a value if a cell is greater than 0.
if the cell is 0 or less I want the formula to return $0.00.
=IF(C4>0,HLOOKUP(B4,Sheet3!B5:D10,3,FALSE))
I attached the spreadsheet as well.
Thank you,
PS
Last edited by pleasesmile; 06-07-2013 at 09:26 PM.
Looks like that should be Vlookup, not Hlookup.
And you just need to add the ,0 at the end.
=IF(C4>0,VLOOKUP(B4,Sheet3!B5:D10,3,FALSE),0)
=IF(C4>0,HLOOKUP(B4,Sheet3!B5:D10,3,FALSE),0)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi,
It's VLOOKUP you should be using, not HLOOKUP.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks