Match Text from a File Name

bFer

I am looking for some advice on how to write a formula.

Example: Match spot names from Spot Column (Sheet 2) to Asset Filename (Sheet 1) and return "Betrayal" to the Spot column.

Sheet 1:

Sheet 2:

Thanks kindly for any advice.

Leibel S

@bFer

See below formula, replace spot:spot with your cross sheet reference

=JOIN(COLLECT({spot:spot}, {spot:spot}, CONTAINS(@cell, [Asset Filename]@row)), " ")

bFer

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