Not Exact Match

Nana250

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.

Paul Newcome

The best thing you could do is to change the 0 to a 1 at the end of your MATCH function, but even that is going to prove to be unreliable. Consistency in your data is going to be the key to this one.