How To Add a Lookup Column To a SharePoint Online List

This tutorial will show you how to add a lookup column to a SharePoint list. Specifically, this tutorial will show you how to add a column to a SharePoint Online list that looks up or references data from another SharePoint list. Lookup columns are a great way for you to create a relationship between two SharePoint Online lists.


Timeline
0:00 - Start
0:50 - What is a lookup column in the context of a SharePoint list?
2:30 - How to add a lookup column a SharePoint list
3:15 - How to select the SharePoint list that you want to look up data from
3:50 - How to add multiple columns from the reference SharePoint list
4:50 - Example of how a lookup column on a SharePoint list works

-MORE ABOUT ME-

LOOKING FOR TRAINING OR CONSULTING - CONTACT ME AT:

LETS BE FRIENDSI

GOT A VIDEO IDEA? FILL OUT THIS FORM:

SIGN UP FOR MY MONTHLY NEWSLETTER

PRODUCTS THAT I USE TO CREATE MY YOUTUBE VIDEOS:

SOFTWARE THAT I USE TO CREATE MY YOUTUBE VIDEOS & CONTENT:

OTHER SERVICES THAT I USE:

Note that I may earn a small commission at no additional cost to you from purchases made using these links.

[ranimaharaj-sharma]

Thank you.. This was very well explained. Short | Simple |To the Point.. Thanks again...

[ieuancilgwri]

Hello Lui - this is great! Is it possible to have a function where you could select multiple items in the list?

[anon-iifx]

i have 5 separate teams space / sharepoint sites. how can i lookup my master list across all these 5 spaces. i don't want to manually re-create the master list in each of the teams space. i would like it to be like a one list to many lists. thanks.

[vs_gaming]

Is it possible to make a conditional lookup column? For instance, I have one column with a country region and a second column with cities. I want to make the following scenario: if I choose region A in column one I want to see in column two the list (dropdown) of all cities belonging to region A. How to make this?

[MawuliAsamoa]

Hey, great video. Thanks for the tutorial. Do you know why after setting this up you cannot add new rows using the edit grid mode? only works when you use the +New button. thanks

[laurapoole]

Do you have a tutorial on adding conditional formatting using JSOM coding to match data from one sharepoint list to another?

[wk]

Hi, thanks for the video. It’s exactly what I’m looking for however, I was hoping if you might be able to answer a question? Is it possible that the lookup auto populate without having to edit and select an option? Thanks!

[hsinghk]

Thanks! Do you know the max number of rows? can it be 1000s?

[matiascontreras]

Hi, thank you for your video. Could please help me with the following issue, when I add an item to table 1 for example, this new item is not available to select in table 2. How can update table 2 and select new items?

[colby]

I have a list with several hundred records already in it. I am wanting to make another list that will reference a few columns from that already created and populated list automatically. I create the smaller list, created a lookup column referencing the list and columns I wanted and nothing is brought in.

[kamilbuszmann]

is there any way to do a lookup column to site pages custom column ? I'm trying and i dont see any of them

[MusicHitsNumberOne]

Congrats for this video! Why doesn't a column I need appear available to select?

[shathike]

Hi, this is good informative, kindly let me know, lookup field not working for date format its visible number format (i.e. 44, 745) please guide me how to change as date format. Thanks

[stephenm.french]

I was able to get this work, but it only works when adding a new item to the target list. It doesn't work if you try to edit older items. Any thoughts? thanks.

[KaiHansen]

Hello, thanks for you video, i can't lookup column in 3 tables, the 2 tables is relationship, the 3 table is union the 2 tables, example:
1 table Region, 2 table Zona, 3 Ship
Zona have look column the Region, example:
Table Zona
Zona | Region
Zona 1 | Region 1
Zona 2 | Region 1
Zona 3 | Region 2 ....

Table Region
Region | Name
Region 1 | x

Table Ship
Ship num | Zona | Region
508 | Zona1 | Region 1 <---- Here i wan that automatic display Region

But in the options columns lookup, no display "Region"
Thanks

[gloriarodriguez]

Hi! Is there any other ways to accomplish this? I have a massive excel file (more than 5000 rows) and it will not work because of the threshold limit. Goal is for my customers to enter in one field and have it populate everything related. Thank you in advance.

[baphnie]

Okay, so not to be used as a lookup like we'd traditionally expect. In my case, I'd like to list the Provider and auto-populate info on that Provider from several other lists to one central location. You're saying I'd have to have an extra Provider identifier column for each field I wish to bring in? Yikes.

[joshuawulf]

This doesn't tell us how the two lists are joined. How does the sharepoint list know which column in the target is supposed to be used as the matching lookup value in the source? Any other data joins/lookups I've done have required this.

[issiewizzie]

what happens when you have business units with over 100 departments ...(that's when you need a cascading drop down )