Excel 2007
 

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

Excel 2007
 

Try using INDEX/MATCH, e.g

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

"emitch7910" wrote:

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

Excel 2007
 

We have to use the =vlookup to find three items in seperate worksheets from
the same workbook.
--
Earl Miles Mitchell
Access 2003 Trainee


"daddylonglegs" wrote:

Try using INDEX/MATCH, e.g

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

"emitch7910" wrote:

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