Hi Guys

I have used this formula

=ADDRESS(MATCH(9.99999999999999E+307,F:F),6)

to return the cell reference of the last cell in column F that has a value
in it ($F$13).

How can I get the actual value of the cell returned in a different cell?

Cheers
Aidan