find a match on three other sheets

Answers
-
I'm trying to find a match on three other sheets and this stacked formula, which I thought I mimicked above, is not working. Any ideas what I'm doing wrong? =IFERROR(IFERROR(IFERROR(INDEX({1_Program Tracker - All Other Products Range 9}, MATCH(SKU@row, {1_Program Tracker - All Other Products Range 4}, 0)), INDEX({1_ARCHIVE All Other Products-Program Track Range 5}, MATCH(SKU@row, {1_ARCHIVE All Other Products-Program Track Range 2}, 0))), INDEX({ARCHIVE 2024 WT Everyday Program T Range 1},MATCH(SKU@ROW,{ARCHIVE 2024 WT Everyday Program T Range 2},0)))
-
NVM, I found it on another discussion "As you've found, with nested IFERROR statements, you need one less IFERROR function per formula. This is because the final formula is the result if there
isn't
an error."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!