Is it posible?

[Stapes]

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

 

[Jim Thomlinson]

Take a look at the Vlookup function. That being said I am with you. Based on
what you have posted Access would be a better choice. Heck it's not that
expensive. See if your client will spring for a copy.

 

[Pete_UK]

You would use VLOOKUP formulas to do this, as long as the product code
is in the leftmost column of your table - otherwise, you would use an
INDEX/MATCH combination. All are described well in Excel Help, or you
could come back here with further details if you require more detailed
help.

Hope this helps.

Pete

 

[bc]

A piece of cake with the Vlookup function.