VLOOKUP equivalent -- #NO MATCH error

Hello! I have a formula I'm using across several sheets referring to a source table. On 9/10 sheets, the formula works just fine. However, on one the exact same formula yields a #NO MATCH error. I've double-checked my references and everything looks good -- e.g., the match criteria does indeed exist where it should.

Any ideas? I'm at a loss.

Thanks!

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Andrée Starå

Hi Kolfinna,

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

kolfinna

Hey there!

Went through all the steps to get screenshots and triple-checked my reference table...only to discover I had selected more columns in that sheet than on all the others.

Mistakes were made.

Thanks anyway!

Andrée Starå

Glad you found the issue and got it working!

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.