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

On Thu, 21 Jul 2005 16:30:01 -0700, "Vladymir"
wrote:

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!