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.

Kristin is a content strategist at Techarex Networks. Kristin follows the B2B technology space closely and loves to write on the latest changes in technology, futuretech and fixes for day to day how to issues. Besides writing Kristin also loves music, moves and skating.

Techarex Networks SharePoint Hosting Solutions provides a best-fit collaborative environment,fetching maximum ROI with our world-class SharePoint hosting plans. Our customized deployment helps you to select business-centric configuration. Experience industry-leading SLAs and dedicated 24X7 support, augmenting business needs with world-class industry-ready SharePoint foundation, enterprise, and custom hosting plans.