JOIN function in INDEX/MATCH

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?

Answers

  • Amit Wadhwani
    Amit Wadhwani ✭✭✭✭✭✭

    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/

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!