Howard,
It is all working. I thank you very much. I probably woul have taken me
forever to get the formula correct. Now all I have to do is do an 'If'
stament to get rid of the #N/A. Also in all my looking around I thought I saw
somthing about about getting to the name in the drop-down quicker. At this
time I have 158 names and it is still growing. That is lotsa scrolling.
Again, Thanks
Capt. Andy
"L. Howard Kittle" wrote:
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!