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.

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.

To know more about SharePoint, get in touch with our experts.

Are you in search of an intranet solution? Meet Dock 365, a pre-built SharePoint Intranet Portal ensures seamless collaboration no matter whether your employees are separated by a few cubicles or a few thousand miles. Being a  trusted Microsoft SharePoint technology solution provider, we help customers realize their business goals, desired outcomes, maximize productivity, business growth, ROI and much more. 

Schedule a Free Demo Now

Schedule a Demo