Lookup Column - Import for SharePoint

Destination Column

If you want to;

Set a value in a lookup column.
Import to a list that contains a lookup column
Import to a document library that contains a lookup column

You can use an import mapping of lookup;

Configuration

<ImportMapping xsi:type="ImportMapping_Lookup">
<!-- This is the field of type lookup.-->
<DestinationField>Job</DestinationField>
<SourceColumn>Job Title</SourceColumn>
<!-- This is the list that contains the lookup values -->
<LookupListTitle>Items</LookupListTitle>
<!-- This is the field in the lookup list the value of which 
matches the value in the source column-->
<LookupFieldInternalName>Title</LookupFieldInternalName>
<!-- This is the CAML value type Text,Number,DateTime,Guid,MultiChoice,Lookup 
for the field on in the lookup list that matches the value specified in the 
source column -->
<LookupFieldCAMLType>Text</LookupFieldCAMLType>
</ImportMapping>

<SourceColumn>Job Title</SourceColumn>

<LookupListTitle>Items</LookupListTitle>

<!-- This is the field in the lookup list the value of which

matches the value in the source column-->

<LookupFieldInternalName>Title</LookupFieldInternalName>

<!-- This is the CAML value type Text,Number,DateTime,Guid,MultiChoice,Lookup

for the field on in the lookup list that matches the value specified in the

source column -->

</ImportMapping>

Source

The source could be;

Import Excel Data to SharePoint (7/10/2018)
Import ODBC Data to SharePoint (7/10/2018)
Import OleDb Data to SharePoint (7/10/2018)

Further thoughts

If you want to;

Set a value in an external lookup column.
Import to a list that contains an external lookup column
Import to a document library that contains an external lookup column

Then do get in touch.