enter a value, excel pulls information and places in new spreadshe
 

I have a workbook that has 2 worksheets. The first worksheet called
"pricelist" is a list of items and prices in multiple columns, and the first
column is a unique identifier. The second worksheet is "invoice". I want to
be able to type in the unique identifier in the "invoice" spreadsheet and
have excel find the coresponding information in the "pricelist" spreadsheet,
and then place that information into the "invoice" worksheet in several
columns.

A. What is doing this called?
B. How can I do this?

Thank you for any help.

enter a value, excel pulls information and places in new spreadshe
 

A. What is doing this called?

It's called a lookup.

B. How can I do this?

See this:

http://contextures.com/xlFunctions02.html

Biff

"TechieRandy" wrote in message
...
I have a workbook that has 2 worksheets. The first worksheet called
"pricelist" is a list of items and prices in multiple columns, and the
first
column is a unique identifier. The second worksheet is "invoice". I want
to
be able to type in the unique identifier in the "invoice" spreadsheet and
have excel find the coresponding information in the "pricelist"
spreadsheet,
and then place that information into the "invoice" worksheet in several
columns.

A. What is doing this called?
B. How can I do this?

Thank you for any help.