LOOKUP, IF formula problem

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula:

=LOOKUP(9.999999999999E+307,IF(L65>=0,L65,IF(J65>=0,J65,IF(H65>=0,H65,IF(F65>=0,F65,IF(D65>=0,D65,IF(B65>=0,B65,IF(L50>=0,L50,IF(J50>=0,J50,IF(H50>=0,H50,IF(F50>=0,F50,IF(D50>=0,D50,IF(B50>=0,B50,IF(L35>=0,L35,IF(J35>=0,J35,IF(H35>=0,H35,IF(F35>=0,F35,IF(D35>=0,D35,IF(B35>=0,B35,IF(L20>=0,L20,IF(J20>=0,J20,IF(H20>=0,H20,IF(F20>=0,F20,IF(D20>=0,D20))))))))))))))))))))))))

 

ok, the issue is: if I use : IF(L65>0,L65 …etc , everything works like a charm, but if I use the >= combination it turn #N/A.

I am really stuck, do not know what to do, I need to use 0 in next cell to clear the value as there is another sheet reading and calculating the last value, so when for an example: this month I have to make these payments, but, next month some of them I shall not pay, so, I need to zero the value for next month.

Thank you for your help

 

By: Demetris

81 thoughts on “LOOKUP, IF formula problem

  1. Magdalen Elsen

    My spouse and i ended up being now excited when Albert could finish up his research from the precious recommendations he discovered from your own web page. It’s not at all simplistic just to possibly be releasing strategies which often men and women could have been making money from. And we consider we have got the blog owner to thank because of that. All of the explanations you made, the straightforward website menu, the friendships your site give support to engender – it is all astonishing, and it’s facilitating our son and us imagine that the issue is awesome, and that is truly serious. Thank you for the whole thing!

  2. Sidney Ramphal

    I blog quite often and I seriously thank you for your information. Your article has truly peaked my interest. I’m going to take a note of your blog and keep checking for new information about once a week. I opted in for your Feed too.

  3. i99bet

    An impressive share! I’ve just forwarded this onto a friend who has been conducting a little homework on this. And he actually bought me dinner because I found it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanx for spending some time to discuss this subject here on your web site.

  4. logo design

    Hey there just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Opera. I’m not sure if this is a format issue or something to do with web browser compatibility but I thought I’d post to let you know. The design and style look great though! Hope you get the issue resolved soon. Thanks

  5. togel sgp

    We’re a group of volunteers and opening a new scheme in our community. Your website offered us with valuable info to work on. You have done an impressive job and our whole community will be thankful to you.

  6. udaipur escorts

    Have you ever considered about including a little bit more than just your articles? I mean, what you say is important and all. Nevertheless think of if you added some great graphics or video clips to give your posts more, “pop”! Your content is excellent but with images and video clips, this blog could certainly be one of the best in its niche. Great blog!

  7. ตู้ม้าออนไลน์ apk

    One more thing I would like to state is that as an alternative to trying to match all your online degree lessons on times that you conclude work (as most people are exhausted when they return), try to find most of your classes on the week-ends and only a couple courses on weekdays, even if it means taking some time away from your weekend break. This is really good because on the week-ends, you will be a lot more rested as well as concentrated in school work. Thanks for the different suggestions I have discovered from your site.

Leave a Reply

Your email address will not be published. Required fields are marked *