Lookup Column in SharePoint
A Lookup column is quite similar to a Choice column as it provides users with a complete set of predefined values for specific column. The benefit is that you can easily point it to any other SharePoint list on the site to create more of the dynamic list values.
It’s a much better option compared to storing all the list values as the column’s static property as users always update the list on account of their normal business operations.
Consider for example, you have an easy-to-understand customer list. It would become quite unrealistic for the site manager to log in and make changes to a list column’s properties constantly whenever the company has acquired a new customer.
Rather, you need to get this column point towards a centralized customer list – a list that only the people closest to your business operations can have the access to maintain.
The name of the new customer would then appear as a specific value in the column automatically when the centralized customer list gets updated. Besides selecting the list & column used by the Lookup column to display data, it’s also feasible for site managers to configure the column in a way that allows users to select multiple values for a single list.
We hope this tutorial explains the concept of Lookup column clearly.