Not Exact Match

Hello - I am using the below formula to bring in the names from another sheet:

=INDEX({Company Name}, MATCH(Name@row, {Name Column}, 0))

This is the example for reference:

My question is if there is something that I can add to my formula that looks for a similar name. The data set i'm looking at the reference sheet isn't always exact to whats in the "Name" column. For example, the "Name" column can say LaBeach and the data set that it references says la beach or la_beach. I will get "No Match" in this instance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!