Partial Match in an INDEX/MATCH
Hi,
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!
Hannah
Answers
-
Hi @Hannah H
Hope you are fine, could you please supply a screenshot ( remover any sensitive data )
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Bassam.M Khalil,
Here is an example of the columns I'm using in both sheets.
My current formula is =IFERROR(INDEX({Requested By}, MATCH([Freelancer's Name]@row, {Freelancer's Name}, 0)), "")
It works great if I have a perfect match on the names, but not if people use a nickname, for instance.
Hannah
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!