I have a long list of automobiles in many different spread sheets.
I have all these cars numbered!
I want to be able to make a work order sheet that the first cell is asking
for a car number, then to fill the rest of the cells based on the input car
number!!
AS an example the cells I have are
car number, year, make, model, vin number
When a person writes up the work order I want them to be able to just put
car number and have all the rest of the fields filled on that number can
anyone help!!!!@

Tim

See Debra Dalgleish's site for using VLOOKUP with Data Validation drop-down
pick list for your car numbers.

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

DV basics.. http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben Excel MVP

On Fri, 4 Feb 2005 13:59:04 -0800, Tim wrote:

I have a long list of automobiles in many different spread sheets.
I have all these cars numbered!
I want to be able to make a work order sheet that the first cell is asking
for a car number, then to fill the rest of the cells based on the input car
number!!
AS an example the cells I have are
car number, year, make, model, vin number
When a person writes up the work order I want them to be able to just put
car number and have all the rest of the fields filled on that number can
anyone help!!!!@