Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to restrict input to a list of values - with a twist
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to restrict user to input only one of multiple cells | Excel Worksheet Functions | |||
Restrict-Filter-Limit-Validate user input in Excel | Excel Discussion (Misc queries) | |||
how do I restrict cell input to dates only? | Excel Discussion (Misc queries) | |||
Restrict input into cell array | Excel Discussion (Misc queries) | |||
Restrict input if amount is exceeded | Excel Worksheet Functions |