LOOKUP,IF problem

[Clwd9Rider]

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

 

[steve the fish]

Hi. I think there should be shorter formulas but this should work:

=IFERROR(LOOKUP(2,1/((LEN(A65:L65)>0)*(A65:L65>=0)*(MOD(COLUMN(A65:L65),2)=0)),A65:L65),IFERROR(LOOKUP(2,1/((LEN(A50:L50)>0)*(A50:L50>=0)*(MOD(COLUMN(A50:L50),2)=0)),A50:L50),IFERROR(LOOKUP(2,1/((LEN(A35:L35)>0)*(A35:L35>=0)*(MOD(COLUMN(A35:L35),2)=0)),A35:L35),IFERROR(LOOKUP(2,1/((LEN(A20:L20)>0)*(A20:L20>=0)*(MOD(COLUMN(A20:L20),2)=0)),A20:L20),"NA"))))

 

[Clwd9Rider]

THANK YOU SOOOOOOOOOOOOO MUCH, changed some parameters and it worked like a charm, THANK YOU