INDEX and MAX gets Invalid data type match

I have the reference to the MAX working correctly and pulls the newest date, but when I add it to the index to pull the information from the text field in the associate sheet I get invalid data type. Am I missing something? Can you advise?

=INDEX({Display by Tech Range 2}, MAX({Display by Tech Range 1}), 0)

Display by Tech Range 2 is text/number

Display by Tech Range 1 is create date

The display column is text/number. The goal is to do a compare and set a yes/no check box for establishing a user specified report filter.

Find more posts tagged with

Accepted answers

Paul Newcome

There are a couple of issues...

You indicated the MAX function is pulling a date, but you have it in a position within the INDEX function that requires a numerical value. You also have 0 set as the column number to pull from. There is no column 0. At the very least you would need to change this to a 1.

Try this instead...

=INDEX({Display by Tech Range 2}, MATCH(MAX({Display by Tech Range 1}), {Display by Tech Range 1}, 0))

All comments

Paul Newcome

There are a couple of issues...

Try this instead...

=INDEX({Display by Tech Range 2}, MATCH(MAX({Display by Tech Range 1}), {Display by Tech Range 1}, 0))

Terilyn

Thank you!

Paul Newcome

Happy to help. 👍️

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.