Can't update specific record due to Duplicate email address

Question

Hello,
I am tasked with updating a data value (Shore Ex Code) on around 2K records in Marketo.
I have been provided an excel document with the list of contacts whose records need to be updated.
The problem I am running into is that some email addresses have duplicate records.
Case in point: 
This person below signed up for two GVR accounts using the same email address.
They were assigned a unique Member ID for each account via our CRM and then added to the GVR Person Partition in Marketo:
In the excel doc I was provided (see below), the record with Member ID GVR06288EHZ should be assigned the Shore Ex Code in Marketo:

However, when I uploaded the excel doc to Marketo, the account with Member ID GVR34921EMZ was updated with the Shore Ex Code.
Is there any way for me to ensure that when dealing with duplicate email addresses, a specific record is updated and not a different one?
Thank you,
LK

SanfordWhiteman · Accepted Answer

You can’t target one specific person record using a standard UI-based list upload and default dedupe rules.

You can target the record in 2 ways:

using an API-based list upload, which can lookup on a custom field
calling a webhook call to a service that can match people based on a custom field (you pass the webhook your {{lead.Member ID}} and it looks that up in a spreadsheet/file/local list/whatever)

Sign up

Login with SSO

Login to the community

Login with SSO