Lookup 2nd last value in a range

[ronie85]

Hi, I have a formula that looks up the last value in a range. This formula is =LOOKUP(2,1/(L2:BI2<>""),L2:BI2)
I would like another formula to look up the 2nd last value in a range.
Could someone supply this for me please?

Thanks in advance

 

[Fluff]

Do you have formulae in those cells, or are they totally empty?

 

[ronie85]

The range all have values in them, they are formulas.

=LOOKUP(2,1/(L2:BI2<>""),L2:BI2) works for column G, but I requrie the 2nd last for column H, 3rd last for column I etc.

 

[Fluff]

Ok, how about in col G only

=CHOOSECOLS(FILTER(L2:BI2,L2:BI2<>""),-1,-2,-3,-4,-5)

 

[ronie85]

That is even better, thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.