How do I use Excel 2007's Lookup function to find information on another
spreadsheet in the same workbook and display that information into cells
corresponding with the information?

For my project, I am needing to type in the Product ID Number into a cell in
one spreadsheet and have it use a function to find three values (Type, Model,
and Price) that correspond with that ID Number in a seperate spreadsheet and
show those values in seperate Cells on the first sheet under the correct
categories.

--
Earl Miles Mitchell
Access 2003 Trainee