In this SharePoint online tutorial, we will discuss lookup column in SharePoint online or SharePoint 2016/2013. We will see how we can create a lookup site column and then we can add the lookup site column to a SharePoint online custom list.
What is SharePoint Lookup Column?
SharePoint Lookup columns are very much helpful when you want to display data which are presented in a separate list. In the large enterprise, there are list data which may be related to another list in SharePoint Online or SharePoint 2013. In those cases lookup columns are ideal. By using a lookup column, we can display data in one list from another list in SharePoint.
Here I have custom list known as “TrainingEnquiry” which has two columns as:
- Title
- TrainingType (Choice column having values Online/Offline/Classroom)
The list looks like below:

Here I wanted to add another lookup column as TrainingCourses, and the data will come from another list known as “TrainingCourses“.

SharePoint Supported Column Types for SharePoint lookup column
Below are the column types which are supported for SharePoint lookup columns.
- Single line of text
- Number
- Date and Time
SharePoint Unsupported Column Types for SharePoint lookup column
Below are the column types which are not supported for SharePoint lookup columns.
- Multiple lines of text
- Currency
- Person or Group
- Calculated
- Hyperlink or Picture
- Custom Columns
- Yes/No
- Choice
- Lookup
Create Lookup Site Column in SharePoint Online/2013/2016
Now we will create the site column of type lookup column. Open SharePoint Online Site Settings page then click on “Site columns” which is under “Web Designer Galleries“.
If you are new to site columns, read What is site column in SharePoint?
In the Site Columns page, click on Create like below:

Then in the Create Column page, Give a name for the Site columns and choose “Lookup (information already on this site)” radio button from the data type like below:

Then in the group, either you can add to any existing site column or you can create a new site column like below:

Then in the additional Column Settings, give a description of the column and then in the Get information from: choose the list name from which you want to bring the data. Then “IN this column”, choose the column which you want to show, here I have chosen Title column.

Then click on OK which will create all the lookup site column. And you can verify this from the Site Columns page. Choose show group as “SharePoint Site Columns” and then you can see the column.

Add Lookup Site Column to SharePoint Online List
Now we will see how we can add the site column to the SharePoint Online/2016/2013 list. Open the list, click on List Settings from the ribbon which will open the List Settings page. There click on “Add from existing site column” like below:

Then in the “Add Columns from Site Columns” page, Select the group as our custom group name. And from the available columns choose the column and click on Add>.

Click ok, now the column will get added to the list.

Now if you will go to the list, and try to add one item to the list, you can see the lookup column details like below:

Select Additional Column from the Lookup column
In the lookup column, we have an additional column as “Duration”. If you want to show the additional column in the list, you can follow below steps.
Go to the list settings page. Click on the Courses lookup column. And then go to the “Additional Column Settings” section and select the additional “Duration (months )” column like below:

Now when you will add one item, you will add values for Title, Training Type and Courses, but the Duration (months) column will appear like below:

Read some SharePoint customization tutorials:
- SharePoint List View Threshold: Your FAQs Answered
- How to add header and footer to list view web part using JSLink in SharePoint 2013?
- SharePoint 2016 List View Auto Indexing Automatic Index Management
- Add, Update, Delete & Display List items in Gridview Programmatically in SharePoint 2016
- How to Add List View Web Part in SharePoint Online Modern Site
Conclusion
I hope this tutorial will be helpful to know about SharePoint lookup column. How to create a lookup site column in SharePoint 2013/2016 or SharePoint Online. Also, we have seen how to add a lookup site column to a SharePoint Online list.
I am Bijay a Microsoft MVP (8 times –Â My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com
Hi Bijay,
i need to count number of semicolons present in a column(single line of text) and count should reflect in next column. Please help me
Hi Bijay…
Simple and great instructions. I ran into a problem when I went to go export the data to excel as the date and number formatting are not the same as in SharePoint. Here is a link I asked for help form MS. Not sure if you might already know how to fix?
https://docs.microsoft.com/en-us/answers/questions/367903/export-to-excel-sharepoint-2013-date-and-number-in.html#answer-369460