Partial Match in an INDEX/MATCH


I currently have an INDEX/MATCH that is pulling in a variety of data from sheet A into sheet B. I am using the Freelancer's name to match across the sheets.

The problem I am facing is that in sheet A, an internal employee adds the Freelancer's name. In sheet B, the Freelancer adds their own name (via a form) and when these aren't identical (because a nickname or an initial might be used), the data from sheet A doesn't pull across.

Is there a way I can create a partial match? I know Smartsheet doesn't support wildcards, so I think CONTAINS is my only option? Can I build a formula that would just look at the last name of the Freelancer? Although I wouldn't know the length of the last name...

Any help much appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!