See Debra Dalgleish's site for dependent dropdowns using Data Validation
Lists

http://www.contextures.on.ca/xlDataVal02.html

For entering the price use a VLOOKUP formula.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Mon, 22 Dec 2008 11:28:02 -0800, SeanO
wrote:

I am trying to create an invoice that has two drop down lists. One is the
Category eg.(audio, video, misc) once I pick one of those the second dropdown
list shows only products related to that category. I would like to choose a
product and have it fill out the price for that product. So it goes category
then description of product and finally price. How would I go about creating
that?

thanks!