Insert Last Entry into cell

[ARJUNDSOUZA]

Dear Gurus,

I am looking for a formula that can look for the last entry in a range of cells.

Eg: Attached sheet - last entry in Column B (range B2:B32) is 1,596,088 - similarly other columns.
I want to know if there is a formula that can be inserted in Cell B33 which will always look up the range B2:B32 and display the last entry in cell B33... similarly for others C33, D33.

Thanks in advance for your inputs.

Kind regards
Arjun

 

[pecoflyer]

In B33 and drag right =INDEX(B17:B32,MATCH(9.9999E+307,B17:B32))

 

[ARJUNDSOUZA]

Awesome!! Thank you @pecoflyer