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
Check out the Formula Handbook template!