+ Start a Discussion
honda57honda57 

Mass Updating a lookup field

Is it possible to import data to a lookup field via Excel connector or otherwise?
 
I have a batch of leads to import including a field called "partner".  I am trying to send this partner data to a custom lookup field on the lead object (also called "partner").  It won't let me.
 
Even if new lookup value records are created, it will save a ton of time if I can import this data....
JimRaeJimRae

You should be able to, but remember, you need to import the id of the lookup, not the text value.

Jim