Find the value of a cell one above

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