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

2,964 thoughts on “LOOKUP, IF formula problem

  1. healthy fresh recipes

    After exploring a handful of the blog articles on your blog, I truly like your technique of blogging. I saved it to my bookmark site list and will be checking back in the near future. Please check out my website too and tell me what you think.

  2. 谷歌优化

    Please let me know if you’re looking for a writer for your weblog.
    You have some really good articles and I believe I would be
    a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange
    for a link back to mine. Please shoot me
    an e-mail if interested. Cheers!

  3. hiking

    Greetings! Very helpful advice in this particular article! It’s the little changes that will make the largest changes. Thanks for sharing!

  4. Mauro Kwiecien

    I am often to blogging and i really appreciate your content. The article has really peaks my interest. I am going to bookmark your site and keep checking for new information.

  5. Ivory Klicker

    When I originally commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove me from that service? Thanks!

  6. Ward Steenhuis

    This web site is really a walk-through for all of the info you wanted about this and didn?t know who to ask. Glimpse here, and you?ll definitely discover it.

  7. https://genolyze.com/

    Good post. I learn something new and challenging on blogs I stumbleupon on a daily basis. It’s always exciting to read through content from other writers and use a little something from their sites.

  8. Moises Oblander

    When I originally commented I clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove me from that service? Thanks!

  9. toko online 88

    I’m very happy to find this site. I need to to thank you for your time for this particularly wonderful read!! I definitely appreciated every little bit of it and i also have you book-marked to check out new things in your web site.

  10. Jeanmarie Ridgnal

    Oh my goodness! an amazing article dude. Thank you However I am experiencing issue with ur rss . Don?t know why Unable to subscribe to it. Is there anyone getting identical rss problem? Anyone who knows kindly respond. Thnkx

  11. https://poboleda.org/

    Hi, I do believe your website could possibly be having browser compatibility problems. Whenever I look at your blog in Safari, it looks fine but when opening in IE, it’s got some overlapping issues. I merely wanted to give you a quick heads up! Apart from that, great site!

Comments are closed.