Error using IFERROR with Index/Match

Alexandra Prescott

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!

Antonio Figueroa

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