Match + field is checked, check this box

Hey all - having trouble with this formula. I just need a box to be checked if:

If the number id in sheet A is found on sheet B AND the box on sheet B in a second column is checked…then check the box in sheet A

Here's what I have so far - maybe it should be AND(INDEX(?

=IF(INDEX({UCA E#}, [E# or Group]@row, {Affiliate individual}, true), true, false)

Find more posts tagged with

Accepted answers

Nate@E

This works actually:

=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))

Pulled it from SS help documents…go figure lol.

thanks for your help @Michelle Choate 2

All comments

Michelle Choate 2

Try this: =IF(AND({UCA E#}, [E# or Group]@row,{Affiliate individual}, true), true, false

Nate@E

Thanks @Michelle Choate 2

I got an invalid data type.. So it doesn't need index? [E# or Group]@row has to look for a match in the whole column of {UCA E#} and then if it finds a match it needs to only check the box if {Affiliate individual} on that same row it found is checked.

Nate@E

This works actually:

=INDEX({Column to return}, MATCH("Matching Value", {Column with value to match}, 0))

Pulled it from SS help documents…go figure lol.

thanks for your help @Michelle Choate 2

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.