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