IFERROR INDEX MATCH Returning Duplicates

It seems as though my formula is returning multiples but only on one record (where it pulled it over fifteen times). Any idea what can be causing this?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Tabitha W

    Hope you are fine, could you please add a copy or screenshot contains columns headers and a sample of what the formula return and the reference sheet the you collect the data from using index formula.

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Tabitha W.
    Tabitha W. ✭✭✭✭

    Sure. Here is a ss of the sheet where the error is returning:

    Here is the formula that I believe is problematic:

    Source Sheet:

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!