USING LOOKUPs but not working Libreoffice

[ZaferCelik]

=IF(OR(F16=0;F16="");"";(G16-IF(OR(G15=0;G15="");LOOKUP(2;1/((G$3:G14<>"")(G$3:G14<>0));G$3:G14);G15))/(F16-IF(OR(F15=0;F15="");LOOKUP(2;1/((F$3:F14<>"")(F$3:F14<>0));F$3:F14);F15))*100)

It works in MS excel but not in Libreoffice.
LOOKUP(2;1/ formula doesn’t work in Libreoffice
How should I write it in Libreoffice that will work?

[mariosv]

Please take a look to this thread:

How do I lookup and return a most recent value?

Hello, I am working on a spreadsheet in which I need a formula to return the most recent value in a row from a lookup. I have had the formula working whilst I have been using the lookup function using Microsoft Excel but when i have transferred my file over to Libre the formula’s no longer work. The excel formula I have been using is LOOKUP(2,1/($A$1:A5=A6),$B$1:B5)). Sheet as follows: A1 = A B1 = 10 A2 = B B2 = 20 A3 = A B3 = 15 A4 = C B4 = 12 A5 = D B5 = 30 A6 = ??? …

[ZaferCelik]

thank you. This formula worked.

=IF(OR(G5=0;G5="");"";(G5-MAX(G$3:G4))/(F5-MAX(F$3:F4))*100)

I was looking for the last value entered. The most recent value is the largest.