Cross-site lookup column allows you to link SharePoint lists and libraries from any sites within a site collection. It provides an easy-to-use select box for quick search of related items, supports lists with thousands of elements and has a great potential for tuning e.g. cascading drop-downs, filtering and sorting results, adding new items to the linked list, etc.