SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to have a Lookup column that points to a different SharePoint site, hosted on the same SharePoint server?

share|improve this question
Do you use WSS or SharePoint Server? Standard or Enterprise? 2007 or 2010? – AlexPoint Jun 15 '11 at 14:01
@AlexPoint WSS I believe. I know it's 2007 and Enterprise (sortof). – C. Ross Jun 15 '11 at 16:43

A different site yes. A different site collection no. Then you'd need to create your own custom field type. Going to another webapp is another thing altogether (security wise it can be tricky). 1 option could be to move your column to managed metadata if you are using SP2010, or use the BCS.

share|improve this answer
Same site collection, different site. How would I do it? – C. Ross Jun 15 '11 at 16:44
By creating a site column in the root site of the site collection, include that in the content types it's needed – Colin Jun 16 '11 at 12:29

If you create your lookup column as a Site column, then you can use it in all lists and child sites below that site.

Therefore, if you create a lookup at the site collection root, you will be able to use it everywhere in that site collection.

Sadly, there is no easy way of doing a lookup across site collection boundaries.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.