Returm Value

[Aidan]

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

 

[Mike H]

Hi,

Fir a number use

=INDEX(A:A,MATCH(10^23,A:A))

and for text

=INDEX(A:A,MATCH(REPT("z",10),A:A,1),1)

Mike

 

[Aidan]

Hi Mike

Thanks for he quick response, I'll give these a go.

Aidan