Index, Match

Experts,

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.

thank you
EE_Sum.xlsx
pdvsaProject financeAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=INDEX(1:1,MATCH(TODAY(),1:1)+1)
=INDEX(1:2,2,MATCH(TODAY(),1:1)+1)
0
 
Ryan ChongCommented:
or

B4
=IFERROR(INDEX(1:1,1,MATCH(TODAY(),1:1,1)+1), B1)

Open in new window


B5
=HLOOKUP(B4,1:2,2,FALSE)

Open in new window

0
 
pdvsaProject financeAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.