Can you INDEX and MATCH a date

Can you INDEX and MATCH a date from one sheet and return the value in another sheet? Seems like date format not compatible with INDEX.

The formulas that I have tried are;

=INDEX({1509LV_Schedule Range 1}, Description@row, MATCH({1509LV_Schedule Range 2}))

=INDEX({1509LV_Schedule Range 1}, Description@row, {1509LV_Schedule Range 2})

1509LV_Schedule Range 1 and 1509LV_Schedule Range 2 are both date format columns

I keep getting #INVALID DATA TYPE error

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hey @Warren Labuschagne

An Index/Match has the syntax

=INDEX({range of what you want returned}, MATCH([your match]@row, {Range it can match to},0))

Your Range #2 shouldn't be a Date column if your Description@row is really a Description field. Range #2 needs to be the same thing Description@row is.

Does this help you get closer?

Kelly

All comments

Kelly Moore

Hey @Warren Labuschagne

An Index/Match has the syntax

=INDEX({range of what you want returned}, MATCH([your match]@row, {Range it can match to},0))

Your Range #2 shouldn't be a Date column if your Description@row is really a Description field. Range #2 needs to be the same thing Description@row is.

Does this help you get closer?

Kelly

Warren Labuschagne

https://community.smartsheet.com/discussion/comment/341284#Comment_341284

@Kelly Moore thank you very much, it's working!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.