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,

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

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.

Genevieve P.

Hi @Josh Salvador

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

Josh Salvador

@Bassam Khalil and @Genevieve P. ,

Thank you so much for your help. This worked perfectly. I appreciate the support.

Sincerely,

Josh

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.