IF(AND(MATCH() Between Different Sheets Formula Assistance

I know I must be overthinking this…

I need a formula that basically states IF [IDCode] in {Sheet A} matches [IDCode] in {Sheet B}, AND [Response] in {Sheet B} is "Yes", then checkbox in {Sheet A} is checked, if false, then checkbox is unchecked.

I've tried every combination of IF(AND(INDEX(MATCH I could think of to make this work and I keep receiving #UNPARSABLE or #INCORRECT ARGUEMENT SET errors.

Thanks in advance!

Michael

Find more posts tagged with

Accepted answers

All comments

Spoonhead

You should be able to achieve this with a combination of IF, MATCH, and INDEX.

Ensure you have two sheets, Sheet A and Sheet B.
In Sheet A, create a column for the checkbox.
In Sheet A, use the following formula in the checkbox column:

=IF(AND(NOT(ISERROR(MATCH([IDCode]@row, {Sheet B IDCode}, 0))), INDEX({Sheet B Response}, MATCH([IDCode]@row, {Sheet B IDCode}, 0)) = "Yes"), 1, 0)

Make sure to replace {Sheet B IDCode} and {Sheet B Response} with the actual references to the columns in Sheet B.

This should solve your problem. If you encounter any issues, double-check that the column names are correctly referenced and the column types match the expected data types.

MWilkesen

@Spoonhead

HECK YEAH!! Thank you, I didn't even think to use ISERROR and NOT functions!

I GREATLY appreciate your assistance!

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.