Comparing two columns

Hi Everyone,

I have created two drop down columns. So for example purposes: lets say column A contains 5 grocery items (bread, milk, butter, potatoes, chicken) and those are my mandatory items. Drop down with multiple entries

Columb b has the same 5 things - but when we take stock we only have 4 grocery items (milk, butter, potatoes, chicken) Drop down with multiple entries

how do I formulate Column c to report my missing item (bread)

I figured:

=INDEX([Certificates Obtained]@row, MATCH([Certificates Required]@row), 0))

IMPARSEABLE 😐️

Find more posts tagged with

Accepted answers

All comments

alindberg

=INDEX([Certificates Required]@row, MATCH([Certificates Obtained]@row, 0)) I just changed my columns around and now I get #NOMATCH, however I would like it to return what is missing from the index. I dont know if it is possible

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.