You could create a lookup table with truck numbers column and corresponding data
columns.

Then a VLOOKUP formula in each cell to be filled.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

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

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

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

On Fri, 4 May 2007 10:33:01 -0700, FletchLives
wrote:

I am using dropdown lists to fill in data on a worksheet. I would like to
have the date autofill when a selection is made from the 1st dropdown list.
I have a list of truck numbers. When I select a particular truck number I
want the VIN number, Make, Model etc. to automatically be inserted in the
appropiate cell. How do I link the cells or create a formula to recognize
the data and insert the corelating data?