Index/Match working for some of the entries, but not all

BFuller

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.

Paul Newcome

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).

Paul Newcome

What is the formula you are using?

BFuller

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})

Paul Newcome

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).

BFuller

That helped, thank you!

Paul Newcome

Happy to help. 👍️