Referencing information in a excel work book.

Hey all,

At the office here we run a invoice/quote excel sheet that each page references each other to make a invoice, packing slip, quote, customs papers and such, but now we are looking at implementing a pricing sheet that will allow us to have all of our products in it with product description and price.

What I am wondering is, how can I add all this information in then have it so if I select for say "Logitech Mouse" that the product description automatically comes up in the cell beside it, along with price beside the description?

I was looking into VLookup but that wont work, so I'm not really sure what to do here..

Any help would be great help,

Thanks

Jay