Please, explain this formula =LOOKUP(2,1/(A2:A10<>0),A2:A10)

[Dudi Shvejk]

Hi everyone.
I wanted to find a fumction that would return the last value more than zero form a particlular column.
I found this formula on "xl-central.com" — [FONT=&quot]=LOOKUP(2,1/(A2:A10<>0),A2:A10).
[/FONT][FONT=&quot]It works perfectly, but I can't understand how it bloody works!!!! And it annoys me as hell!
Could anyone do me a favour, please, and explain the reasoning behind this formula? [/FONT][FONT=&quot]
Thank you very much in advance![/FONT][FONT=&quot][/FONT]

 

[MARZIOTULLIO]

worksheet function - Excel Formula To Get LAST Non-Zero Value in Row and Return Column Header - Super User

 

[Dudi Shvejk]

Thank you! I guess I just don't think like a mathematician to dig this fully