Help with COUNTIFS formula

Hello all,

I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing around with a V-LookUp formula but received feedback that the below formula may be a better option:

=COUNTIFS([Staff Info ID]1:[Staff Info ID]3147=[RNs List ID]1:[RNs List ID]3332)>0, "output if true", "output if false"

I keep receiving error messages when inputting the above formula. Any help would be greatly appreciated!

Find more posts tagged with

Sheets

Formulas

Support

Cell linking

Countif

Accepted answers

All comments

jpaul

assuming that [staff info ID] is the new ID numbers you are using and you want to see if those numbers appear in the old [RNs List ID] list.

=Countif([RNs List ID]:[RNs List ID],[Staff Info ID]@row)

Anything above 0 appears in both list. If you want it to return a statement just add =IF with it

=IF(Countif([RNs List ID]:[RNs List ID],[Staff Info ID]@row) >0,Yes,NO)

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.