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 update...