OverView

In this post,I want to show u how to add a look up column in my list or library that looks up data which comes from a list or library of another site.

I have to say,it is a awesome Function and easy for sharepoint end users.So,Let me guide you through this .And,more remarkable,as long as you must stay in the same site collection.You can create a lookup Site Column that will be used to get information from list which is available in a parent site.The Site Column must be created in the same site as the referenced list/library.

So Let's go ahead.

Step by Step-> Create Lookup Site Column in a parent site(root website)

• Go to Site Action then Site Settings
• Click on Site Columns in Web Designer Galleries

• Click on Create and Create a new Site Column

• Type in a Distinguished name and Select the type in this column is Lookup

• Put this site column into Existing group.for example Custom Columns

• Select a List/Library as information source

• Check it Whether Exist in Custom Columns Group

• Add my Site Column to any list/library you would like to use it with.Just Click on List Settings on Ribbon Menu.

• Click on add from existing site columns

• Select site columns form custom columns

• Success.Look up column looking for values of a list/library on another parent site.

• Just click on the hyperlink as shown in below and finally pop up a dialog to show information.

• Pop up a dialog to show relevant information.

Note:When you click hyperlink . Unfortunately get a error "List does not exist.The page you selected contains a list that does not exist. It may have been deleted by another user".

To Fix this error,just install the latest update of sharepoint and the bug will disappeared.