Index/Match Logic

Hey all, I'm having a moment. lol

I have a functional index/match formula that confirms matches in List A and List B, in different worksheets:

=INDEX({List_A}, MATCH(List_B@row, {List_A}, 0))

What if I want to run logic such as:

If in {List_A}@row but not in List_B:List_B, "say something" ?

Do I need to have a copy of List_A in sheet B?

Thanks!

Find more posts tagged with

Accepted answers

All comments

In your first formula, on Sheet B, you're pulling in values from Sheet A List_A column that have the same value as those in List_B. That's fine, no problem.

But now you want to find the values that are in Sheet A List_A that are NOT in Sheet B List_B? Where do you want to display these - on Sheet A or Sheet B?

Or are you just trying to determine IF there are values in List_A that are NOT in List_B, and if there are, display a message? If this is what you want, you could use a formula based on the following:

=IF(COUNT({List_A}> COUNT(List_B:List_B), "Items in List A not found in List B", "Counts Match")

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.