If you want to show the last value of the Excel sheet column, here is a formula for you.
=LOOKUP(2,1/(B:B<>""),B:B)
If you want to reference another sheet, you can use it. =LOOKUP(2,1/(Bank!E:E<>""),Bank!E:E)
Bank in this formula is the name of the sheet, which you want to reference.
