Drop down list

[biben]

Hi!
I have a sheet that is an invoice and and in another excel-file I hav
all the products with columns like this:

Order Number, Product Number, Description, Model, Type,Price

I want to put a dropdown list on my invoice sheet to look up the righ
product and then fill in the rest of the row in the Invoice. In m
products list there can be the same Order Number more than once bu
then the model is different so I would like to see all data in th
dropdown list so I choose the rigth product.

Or is there a way to put my products in a database Access or MySQL an
have a query in excel to pick only the right product from the databas
with the dropdown list in excel.
Or can it be done using Macro-code

How do I get this to work?
Someone that can guide me as I´m a newbe to all this?

/bibe

 

[Jim]

Go to www.myweb.cableone.net/twodays and down load the "Named Range" file.
You will see how that is done with a combination of Data Validation, nmaed
ranges and the INDIRECT worksheet function. Another example is at
www.contextures.com

 

[sam#1]

I did something similar with a Data Validation menu and
vLOOKUP (or "IF" function if u have <=7 fields, use the
Vlookup if you have more than 7)...
sam

 

[Jim]

There are many ways to skin a cat.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
I did something similar with a Data Validation menu and
vLOOKUP (or "IF" function if u have <=7 fields, use the
Vlookup if you have more than 7)...
sam