Lookup column is a very powerful type of column that can be used in any list or library to get information from another list or library on the site. This functionality can be used to centralize and protect your information (for example list of your Customers) and then do a lookup to it from various lists and libraries. This video goes more in depth to show how you can allow multiple values to be selected or enforce unique values in the lookup column.
Please log in in the pane to the right, to view this video tutorial.
If you are not a member of the site, please look into subscription options.