"#NO MATCH" Error

I was using "COUNTIFS" formulas and they were working completely fine until today all of them are giving me an "#NO MATCH" error. Everything seems fine with the sheet and the formulas. Would you happen to know why this might be happening.

Formula: =COUNTIFS(Status:Status, OR(@cell = "Requested", @cell = "Demoed"), [Automation Category]:[Automation Category], OR(@cell = "Data Processing", @cell = "Data Visualization", @cell = "Robotics", @cell = "Workflow"))

Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

Double check your source data to see if that error is present anywhere. Are any of the ranges you are referencing populated with a VLOOKUP or an INDEX/MATCH?

All comments

Paul Newcome

Double check your source data to see if that error is present anywhere. Are any of the ranges you are referencing populated with a VLOOKUP or an INDEX/MATCH?

Tahreem Tariq

Yes, I do see an error in the source data. It's referencing a Vlookup which is giving the "#NO MATCH" error. Thank you!

Paul Newcome

Happy to help. 👍️

mgilkessmith

@Paul Newcome I am having a similar issue but I need to also use the vlookup in the range that I am using with my countif formula. How do I count all the cells in a column that are populated with a number and not text if there is a vlookup formula being used?

Paul Newcome

@mgilkessmith I'm not sure I follow. Are you able to provide some screenshots for reference?

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.