Index, Match

Posted on 2016-08-29
Last Modified: 2016-08-29

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
Question by:pdvsa
LVL 43

Accepted Solution

Saqib Husain, Syed earned 500 total points
ID: 41775702
LVL 50

Expert Comment

by:Ryan Chong
ID: 41775719

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

Open in new window


Open in new window


Author Closing Comment

ID: 41775733
Thank you!

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dropbox in Windows Server 2008 4 32
Excel Calculate Average - Grouped Values 7 23
Msbbox Notice (4 days) 27 59
Excel - conditional formatting on several columns 9 38
Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question