Contents
Create a lookup column
- Navigate to the site containing the list.
- Select the name of the list on the site navigation, or select Settings.
- Find the column headers at the top of the list.
- From the dropdown, select More.
- Under The type of information in this column is, select Lookup(information already on this site).
There are some limitations of Excel files to be used in SharePoint. You cannot directly use VLOOKUP function like that. There is an option in SharePoint list called Lookup column through which you can lookup data from other list.
Where do I find the lookup column in SharePoint?
First, navigate to the list or library where you want to display information from another list or library. Click on +Add column > More. Since the lookup column is considered a classic feature, you can’t find it on the list of available column types right after clicking on +Add column.
When do you create a lookup column in a source list?
When you create a lookup column in a source list, the primary column displays values from the target list column, but you can also specify that additional, secondary columns from the target list also display alongside the primary column and the other source list columns.
How is a lookup column different from a site column?
By the way, a lookup column is quite different from a site column, which is built at the site collection level and can be used across subsites within that collection. A site column, just like a standard lookup column, doesn’t provide any value across site collections like managed metadata can. How to create a lookup column?
How many lookup columns can I create in a view?
According to Nate Chamberlain, you can only have a max of 12 lookup columns in a view. You cannot create lookups across sites (linked lists and libraries need to reside in the same site) The lookup column only creates a one-way link.