Retreive information from One Sheet to Another

[Guest]

Hi.

I have an excel document with two sheets. On sheet 1 I have a list of items
with three columns (Part Number, Description, and Supplier).

On sheet 2 I have an invoice template with three columns. (QTY, Part Number
and Description).

What I want to do is that whenever a part number is entered on the invoice,
the description field to be filled automatically using the information from
the list on sheet 1.

How is this accomplished?


Thanks in advanced!

 

[Govind]

Hi,

Use VLOOKUP. For eg. use

=VLOOKUP(A1,Sheet1!A1:C5,2,FALSE)

where A1 is the cell in sheet 2 where the Part number is entered and
Sheet1 A1 to C5 is the range where you have the list of items and '2'
denotes the column no. of the description in that range.

Govind.

 

[Gord Dibben]

By using the VLOOKUP Function in the to-be-filled-in-cells.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html

While you're there check out using Data Validation drop-downs for entering
values to lookup.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP