INDEX MATCH formula - not working

Answers

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

    image.png

    dm

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!