A lookup column is a SharePoint list column that retrieves its available values from another column within another list in the SharePoint site.
A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
You can create relationships between lists by using a combination of unique columns, lookup columns, and relationship enforcement (cascade and restrict delete), all of which enhance your ability to create more sophisticated business solutions and help preserve the integrity of your data.
You can read more about lookup columns, here.
