INDEX MATCH formula - not working


  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @roya Your trouble could just be that your column is [Known Issue] but your formula has {Known IssueS]

    = INDEX({remote sheet range Range 1}, MATCH([Local column}@row, {remote column Range 2}, 0))

    ... not sure that is useful, but that is how I think if the syntax for INDEX across two (or potentially more) sheets.

    ... the squiggly brackets are used to designate a range from outside the current sheet.

    ... SmartSheet help should pop up to help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!