=offset(a1, [your formula from below]-1,0,1,1) will give you the last value
in col A.

Change the -1 to -2, -3 , etc for the other cells



"A shink" wrote:

I am trying to locate the last value in a column and then the second to last,
then third to last and so on to be placed in a seperate section of my
spreadsheet.

I am using the following formula to locate the last cell which is:
Lookup(2,1/(A3:A145<"")),A3:A145)

Where do I go from here?

Thanks for the help