Index/Match working for some of the entries, but not all
Hello,
I have a list of LMS students who register via form. When a student registers, I have an Index/Match on both the last name of the person and the email address and compare it to my master list. If they both exist, a number appears in the Current In System column. If not, it says #NO MATCH. Here's the issue, all these that are saying #NO MATCH are actually on my list and I can't figure out why they are matching. I have looked at the last name and it is exactly the same. Same with the email address. I even went in to remove any spaces behind he name and email address in case it was the issue. It's not. I can't figure it out. Especially because I literarily saved the existing sheet as the new current in system sheet and it still wouldn't match to itself. Please help!
Oh, and last thing, when someone is approved, the row copies to the master list and then the number appears in the Current in System field. That way my list is always updated.
Best Answer
-
Try adding a zero to the third portion of your second MATCH function to indicate an exact match (the same way you have it in the first MATCH).
Answers
-
What is the formula you are using?
-
Opps! Sorry...forgot to include that: =MATCH([Learner_EmailAddress]@row, {New Export of Customer Data email address}, 0) + MATCH([Learner Last Name No Spaces]@row, {New Export of Customer Data_bsf Range 1})
-
Try adding a zero to the third portion of your second MATCH function to indicate an exact match (the same way you have it in the first MATCH).
-
That helped, thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!