Note that DV lists have no autocomplete feature as you want.

You would need a CombobBox/DV method for that.

See Debra Dalgleish's site for instructions.

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


Gord Dibben MS Excel MVP

On Sat, 24 Nov 2007 09:20:53 -0800 (PST), "Per Erik Midtrød"
wrote:

On Nov 24, 10:43 am, Sumesh wrote:
I have a pricelist, In my QUotation sheet i want to select the model number
from a drop down list and should get all other details regarding the
description, price etc filled automatically in the curresponding columns of
my quote sheet. How is this possible? When i type the first letter in the
model number column all the items starting with that letter should appear in
the drop down list ..Kindly guide..

Taka a look at data-validation. That will take care of the drop-down-
menu.
Then you could use the vlookup-function to fill in the corresponding
columns.

Per Erik