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")
Answers
-
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")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!