How can I find the last date in Column A that has a corresponding non-zero amount in Column B? Positions of Column A and Column B cannot be swapped on the sheet, so VLookup will not work.
I use this formula to find the last non-zero amount in Column B:
=INDEX(B2:B10, LOOKUP(2, 1/(B2:B10<>0), ROW(B2:B10) - ROW(B2) + 1))
Column A Column B
Date Annual Premium
1/26/2016 $2,813.16
1/29/2016 $0.00
2/23/2016 $928.08
2/16/2016 $8,084.00
2/25/2016 $1,276.56
2/12/2016 $0.00
2/29/2016 $1,077.00
3/3/2016 $0.00
3/6/2016 $0.00
Thanks in advance for your advice!
Rog
Bookmarks