Hi,

Specifically you should look at this

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Rod" wrote:

What I need to do can ALMOST be done with a drop-down list.

My situation is this. I have a list of approximately 500 items in a table.
Next to the item name is a unit cost. So we have a table with 2 columns (A,B)
which are "Item" and "Cost" respectively. This table is on sheet 2 and is
only used for reference.

On Sheet 1, I want to do an estimate. If I could remember the EXACT spelling
of every item, I could just enter the item number and do a lookup of the
price. However, since I cant remember the exact description of each part, I
need a way to look it up based on the first few letter or something.

As I mentioned, a drop-down ALMOST does this, but the problem is I get all
500 parts in the drop-down and it's tedious to sift through.

Is there a way to have it start eliminating choices as I start typing? For
example If I start typing "Br" it begins showing all the items that start
with "Br?"

It doesn't have to be exactly like this, but hopefully I have provided
enough information to convey the idea.

THANKS!