Forum Discussion
Solved
Find the matching cell and then return the cell above it.
I have a "cover page" where you select what fiscal year it is. Call this "cover page" I have a column with all the fiscal years, historical, current, and future. Call this "fiscal year column" E...
=INDEX(A:A,MATCH(D1,A:A,0)-2)
This formula finds the FY two cells above the matching FY.
=INDEX(A:A,MATCH(D1,A:A,0)-1)
This formula finds the FY one cell above the matching FY.
I assume that the FY are sorted in ascending order in column A.
=INDEX(A:A,MATCH(D1,A:A,0)-2)
This formula finds the FY two cells above the matching FY.
=INDEX(A:A,MATCH(D1,A:A,0)-1)
This formula finds the FY one cell above the matching FY.
I assume that the FY are sorted in ascending order in column A.
Thank you! Works perfectly.