bFer✭

Okay, I see, thank you! You were right, that cell was blank which was giving me blank for all. I added the WO#s and it works. I greatly appreciate your time and help with this.

Sure thing, here you go this is the formula currently in WO#: =INDEX({Template - Primary - Work Order}, MATCH(Spot@row, {Template - Primary - Name (no spaces)}, 0)) When I manually type in SpotName2 into "Spot" column i get blank cell in WO#, same.

I checked, still getting no value in WO# Column. I think the issue lies in the JOIN DISTINCT COLLECT formula, the index match is not seeing a match. When I make the "Spot" formula invalid the "WO#" formula sees it. Column "Spot" =JOIN(DISTINCT(COLLECT({Template - Primary - Name}, {Template - Primary - Name},…

okay thanks, let me check this and I'll get back.

That still works, thank you, but when I reference that cell in this formula in WO# column, it still returns blank: =INDEX({Template - Primary - WO}, MATCH(Spot@row, {Template - Primary - Condensed Name}, 0))

Thank you, this is the JOIN formula that is currently working: =JOIN(DISTINCT(COLLECT({Roseville - Reference Sheet Range 2}, {Roseville - Reference Sheet Range 2}, CONTAINS(@cell, [Asset Filename (copy here)]@row)), " "))

Yes please, would make life much easier with "internal" sheets set-up.

This is great, thank you for your help with this!

This is works perfectly, thank you!