Returm Value

A

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
 
M

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
 
Top