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!