Check out this web page of Debra Dalgleish:

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

Scroll down to find instructions for "Auto Complete".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"FloridaCajun" wrote in message
...
I have a VLOOKUP formula set up in cell D9 which uses a drop down list in
D8
(data validation with List in another worksheet) to retrieve a cost of a
radiology or laboratory charge.

All of this works, but I'd like to refine the lookup to a seeded value.

The data list has several hundred entries to choose from. Currently when
the
drop down is activated the list starts with "Ankle" and the user has to
scroll down to "Chest" or "Wrist." Is there a way to seed the lookup in
D8
to begin the drop down at a certain alpha character? For instance, if the
user is looking for the cost of a Wrist 2 View procedure, I'd like to
enter
"W" in D8 and have the drop down begin with W's instead of A's.

Thanks in advance,
Robert