find a match on three other sheets

System

This discussion was created from comments split from: How to create an Index Match Formula for multiple sheets?.

JenniferN

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

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."