I'm working in application build in SharePoint 2007, my question is can we do lookup value of Site Column across Site?
Only possible with third party :
http://www.boostsolutions.com/Cross-SiteLookup.html