Hi

I have a client who is using excel spreadsheets for a Product List,
Customers Orders, Customer Details and Purchase Orders.
He wants to be able to enter a product code in to the Customer Orders
spreadsheet, and have all the rest of the Product Information filled
in or calculated from the Product List.
Similarly he wants to be able to fill in the Customers Details from
the Customers Details file.

Normally, I would do all this using Access, but the client does not
have access. Is it possible to do these things in excel?

For instance, if a Part Number is entered in the Customer Orders file,
how do i get it to find that Product Code in the file Product List,
and return the field Product Description.

Stapes