Using a lookup to return data from a list on a different site

By peter.stilgoe

At first glance this doesnt look possible OOTB but it is, just not very obvious!

The way to achieve this is to:

1) Create a list at say Site Collection level which contains a column with the data in you want to use on another site.

2) Now create a Lookup column at Site Collection Level which is pointing to the data from the above list that you want to use.

3) Now you can add that column, to any list, on any site, throughout the site collection.

December 18th, 2008

Sharepoint / MOSS / K2 /Nintex / IA / BI / InfoPath Consultant