Hey Skipper...Capt.

Looks like you need to do a Vlookup and a list of the boat names in one
column and the boat number in the next column. Your vlookup formula would
look something like this...

=VLOOKUP(A1,F1:G20,2,0)

Where A1 is where you have the dropdown
Where column F is the list of the names of the boats
Where column G is the list of the respective boat numbers

HTH
Regards,
Howard

"Capt. Andy" <Capt. wrote in message
...
I have been getting pretty good with excel but there are things that I just
do not understand.

I have a cell that I enter a name. Some of the names are long and I would
like to make the entry quicker. What is the best way? I think it is a drop
down box but I just do not understand how to get started. Do I make a
list?
What? Help!