Find the value of a cell one above

[jacktaylor110]

I'm trying to create a dashboard that gives a weekly update on my business. I have managed to use the LOOKUP function to find the last/most recent value in my sales list. This works well as it updates on the dashboard when I add in the new value for the week just gone. 

However, I also want another cell to show the second most recent value (i.e. the one above the value found first) to compare this week's value to last week's. How do I do that? Thanks

[#2]

@jacktaylor110 

Let's say the sales data are on a sheet named sales in column K.

The last (bottommost) entry is returned by

=INDEX(Sales!K:K,MATCH(9.99999999999999E+307,Sales!K:K))

The next to last entry is returned by

=INDEX(Sales!K:K,MATCH(9.99999999999999E+307,Sales!K:K)-1)

[#3]

@jacktaylor110 

As variant

=INDEX(Sales!K:K,SEQUENCE(2,,XMATCH(,Sales!K:K)-2))

to return both