#No Match error when using VLOOKUP

I am getting a #NO MATCH error in my VLOOKUP formula which is using a date to return a Period value from an external table. The table example is below.

The formula is below. The date I am referencing in the End Date @row is definetely in the external table above.

Does anyone have any ideas why this is not working?

Find more posts tagged with

Formulas

Accepted answers

All comments

DLanca

fixed this... saw a post suggesting to insert a column to the left of the Primary column and it worked 👍️

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.