find a match on three other sheets

Options

Answers

  • JenniferN
    Options

    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)))

  • JenniferN
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!