Formula - Check box if all three criteria match

Hello,

I have 2 sheets:

Sheet 1: list of videos

Sheet 2: list of products

I want to put a check in the cell for all rows on sheet two where the Title, Edition, and Author match from sheet 1. Here's the formula I am attempting to use:

=IF(Title@row = INDEX({Titles with FX Product Videos Title}, MATCH(Edition@row, {PDP Video List_2023_Completed-Edition}, MATCH(Author@row, {PDP Video List_2023_Completed-Author}, 0) >= 1, 1, 0)))

I am getting an incorrect argument set error message and cannot figure out why. Any help is appreciated.

Find more posts tagged with

Formulas

Accepted answers

All comments

Hollie205

Try

=IF(IFERROR(INDEX(COLLECT({Titles with FX Product Video Title},{Titles with FX Product Video Title},Title@row,{PDP Video List_2023_Completed-Edition},Edition@row,{PDP Video List_2023_Completed-Author},Author@row),1),"")="",0,1)

JenS

Thank you! That did it. Appreciate the quick response.

JenS

@Hollie205 If I wanted to remove the last criteria, would I simply remove the bolded text?

=IF(IFERROR(INDEX(COLLECT({Titles with FX Product Video Title},{Titles with FX Product Video Title},Title@row,{PDP Video List_2023_Completed-Edition},Edition@row,{PDP Video List_2023_Completed-Author},Author@row),1),"")="",0,1)

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.