Lookup Tables

How do I create and then access a lookup table to select predefined records to import into another table? i.e. select standard products for purchase?