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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!