• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 66
  • Last Modified:

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
0
pdvsa
Asked:
pdvsa
1 Solution
 
Saqib Husain, SyedEngineerCommented:
=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
 
pdvsaAuthor Commented:
Thank you!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now