I need to know when is the date for the next transaction and the amount.
I have a simple excel attached. I am not sure if this is an Index, Match.
I have a list of dates along top row and amounts in the cells below. I want to show the date and associated amount of the next amount after current date.
I think it will make sense once you open the file.