How to get IF check box is checked "Order" IF checkbox is unchecked "DO NOT ORDER" working???

I'm stumped. I'm trying to return a "ORDER" If a checkbox is checked and "DO NOT ORDER" if checkbox is unchecked on a reference sheet using index match. Unless I've lost mind I'm pretty sure 0 = unchecked and 1 = checked. I think this should be working,

When I use the formula below I get "ORDER" for INDEX/MATCHED cells that are both checked and unchecked, so I'm missing something...

=IF(INDEX({3.0 IR Sheet - Logi Email Col}, MATCH(Itinerary@row, {3.0 IR Sheet - Itinerary Col}), 0) = 1, "ORDER", "DO NOT ORDER")

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

I have 2 questions. First, is the content you're looking for on the first column? I might try a 1 as I'm not sure that the index is a 0 based function.

Also, how is your list sorted on the referenced sheet? If it is not sorted in an ascending order, then your match won't work. If it is a not sorted list, then you need to add a 0 to the Match function. I would think your formula would look like:

=IF(INDEX({3.0 IR Sheet - Logi Email Col}, MATCH(Itinerary@row, {3.0 IR Sheet - Itinerary Col}, 0), 1) = 1, "ORDER", "DO NOT ORDER")

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.