JOIN function in INDEX/MATCH

Options
e.poc
e.poc ✭✭
in Formulas and Functions

Hello,

I just found the join formula but when i use it my index and match stopped working on another sheet... is there a work around?

· Share on FacebookShare on Twitter

Answers

  • Amit Wadhwani
    Amit Wadhwani Community Champion

    Hi @e.poc

    Can you share some more details what you are trying to achieve. You can check the below formula for your reference. I hope this helps!

    =JOIN(INDEX({id}, MATCH([Name]@row, {Name}, 0)))

    Best Regards

    Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

    https://www.linkedin.com/in/amitinddr/

    Best Regards
    Amit Wadhwani    , Smartsheet Community Champion
    Smartsheet CoE, Ignatiuz, Inc., Exton, PA

    Did this answer help you? Show some love by marking this answer as "Insightful     💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/

    · 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!