vlookup

[Guest]

Hey.
I am using several drop down lists in a worksheet.
Some of the drop downs show the items starting at the top of the list,
others start half way through a list.
Can i make then all start with the first item on the list?

Thanks

 

[Debra Dalgleish]

When you open the Data Validation dropdown list, it takes you to the
first item that matches the cell contents. If the cell is blank, and
there are blank cells in your data validation source list, the first of
these will be selected in the dropdown list.

To prevent this, remove the blank cells from the data validation source
list, or have a default entry in the cell, and the list will open to
that item.

 

[Guest]

Thanks Debra

When you open the Data Validation dropdown list, it takes you to the
first item that matches the cell contents. If the cell is blank, and
there are blank cells in your data validation source list, the first of
these will be selected in the dropdown list.

To prevent this, remove the blank cells from the data validation source
list, or have a default entry in the cell, and the list will open to
that item.

 

[Guest]

Hi Debra.
I have a named array in the source text box rather than just cell references.
The named array has absolute references i.e. $c$1:$c$50
I have several empty cells included in the array to allow for additional
values later.
The cells that have information in them are at the top of the array tho...?

 

[Debra Dalgleish]

Instead of leaving blank cells, you could use a dynamic range as the
list source. There are instructions here:

http://www.contextures.com/xlNames01.html