Excel 2007

[Guest]

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.

 

[Guest]

Try using INDEX/MATCH, e.g

=INDEX(type_range,MATCH(ID,product_range,0))

 

[Guest]

We have to use the =vlookup to find three items in seperate worksheets from
the same workbook.