How do I create a Microsoft Excel look-up table?

I am trying to create a spreadsheet that pulls data from another spreadsheet within a workbook. I have about 600 entries that I'd like it to pull from.