Match Text from a File Name


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!