Index and Match with Today functions in a formula
Hello all,
Reaching out because I have been trying to build a formula for a sheet summary field, and have had no success. I have seen a lot of smart people on here figure out similar problems, so I believe someone has the answer for me.
Basically, I am trying to create an index and match formula that automatically looks for "today" to match with. I have tried several different configurations, and keep getting unparseable.
Is this even possible?
Thank you,
Answers
-
Hi @Josh Salvador
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
The structure of an INDEX(MATCH is as follows:
=INDEX([Value to Return]:[Value to Return], MATCH("Value to Match", [Column to Match]:[Column to Match], 0))
So in your case, something like this:
=INDEX([Value to Return]:[Value to Return], MATCH(TODAY(), [Date Column]:[Date Column], 0))
If this hasn't helped or you're still receiving an error, I agree with Bassam that it would be helpful to see screen captures of your sheet and the formula you're currently using, but please block any sensitive information.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Bassam Khalil and @Genevieve P. ,
Thank you so much for your help. This worked perfectly. I appreciate the support.
Sincerely,
Josh
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!