Forum Discussion
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...
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)