JOIN function in INDEX/MATCH

e.poc

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?

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/