Hi,

This does it for column B

=INDEX(B:B,MATCH(6.022*10^23,B:B))

Mike

"Cadders" wrote:

Hi - is there any way that if I have a column with numbers in each cell, to
be able to put in a formula (without using a vlookup) that will give me the
last value in that column please?
(e.g the column numbers range from 1 to 20 and I want a cell to bring
through the value of 20)

thanks in advance