How to Create a Lookup Column to another SharePoint Site?

Topics: SharePoint Intranet Portal, SharePoint, SharePoint Site, Lookup Column

A lookup column is a referential integrity between the lists in SharePoint. It retrieves one or more values from a target list if those values match the value in the lookup column in the source list.

Advantages of Lookup Columns

You can easily create multiple relationships between lists without using any calculated fields.

Dock 365 Blog - Free E-book download

How to create a SharePoint Lookup Column to another site?

Let's explore how to create a lookup column in a list/library that looks up data from a list/library of another site.Without further ado, let's get started. 

  • Go to Site Contents > Site Settings

Site contents (1)

  • Click on Site Columns

Site Settings-1

  • Click on Create 

Site Columns


  • Give the Site Column an appropriate name and choose "Lookup" as the type.

Create Column

  • Navigate to your Sub site and add your Site Column to any list/library
  • Go to Library Settings

Form Templates   All Forms

  • Click on Add from Existing Site Columns under the Columns section 

Document Library Settings

  •  The next step is to find and add your Site Column

Add Columns from Site Columns

Viola! You have successfully created a SharePoint lookup column to another site.

Dock 365 SharePoint Tutorial Video - How to restore a previous SharePoint Document Version


Don't Get Left Behind!
Subscribe to Dock 365 Blogs!
Stay up to date with the latest business tips and trends.