How to Create a Lookup Column to another SharePoint Site?

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

Written by Sneha Gopal

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.

FREE E-BOOK CTA - 5 Essential SharePoint Online How-to Guides

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.

Creating Hub Sites, Blog Sites, and Team Sites are also some popular queries our users frequently search for. We have done comprehensive blog posts to help them. Take a look at those posts if you find this blog post useful.
Have a nice day! 

Book a Live demo

Schedule a live demo of Dock 365's Contract Management Software now.

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