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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!