Index/Match formula recieving #NO MATCH error message

The formula I am trying to use below should looking at the Short Date column in Sheet B and if there is a match in Sheet A in the Actual End Date column than it should return the value in Sheet B column Fiscal Year.

However I keep receiving a #NO MATCH error - I have double checked all columns have the same column type Text/Number. Help pls?

=INDEX({Short date}, MATCH([Actual End Date]@row, {Fiscal year}, 0))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are both columns set as date type columns?

n7teixeira

@Paul Newcome I had them set up as text/number columns just switched both to date and still receiving same error message..

Paul Newcome

Ok. How is the [Short Date] column being populated exactly?

n7teixeira

@Paul Newcome the short date column on sheet B was all manually input, there is no formula in the column and the column type is date.

Paul Newcome

Try re-entering the dates. It may be that they are still stored as text strings on the back end.

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.