Error using IFERROR with Index/Match

Options

Hello,

I'm trying to add an IFERROR function to my Index/Match formula to obtain data from either of two sheets. See below:

=IFERROR(IFERROR(INDEX({Payment Date}, MATCH($[Invoice Number]@row, {Invoice Number}, 0)), INDEX({Payment Date Final}, MATCH($[Invoice Number]@row, {Invoice Number Final}, 0


This formula gives me an #Incorrect Argument Set error. If Payment Date isn't found in the first set (on my Invoice Tracker sheet), I want it to pull from the second set (on my Invoice Tracker - FINAL sheet). Am I way off?


Thanks for any guidance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!