You will first need a data sheet listing all the products you have:

Code - Desc - Pack - Price


Then on your order form sheet use VLookup function for the Desc - Pack -
Price columns based on whichever code you type in


"MNicholas" <MNicholas@discussions.microsoft.com> wrote in message
news:170B0537-B02A-4CEB-AD34-D03636B90D62@microsoft.com...
> Never really delved all that much into Excel before - not to this level
any
> way so I'm hopeing someone can hold my hand through this. It should be an
> easy one for someone:
> I am trying to design a simple order form. If I enter a product code into
> column A, I want it to fill in the product description, pack size and
price,
> in columns B, C & D leaving me just to fill in the total quantity in
column E.
>
> Then at the end, it should just have a list of the products my customer
has
> ordered in a nice printable page for the sales dept to process. (I can
> probably do the aesthetics and simple calculations)
>
> Hope this makes sense.
>
> Kind Regards.
>