AutoComplete / Data Validation

  • Thread starter Thread starter Musky
  • Start date Start date
M

Musky

I used V-LOOKUP to take an item from a drop down list and have it input a
price into a seperate cell, now the problem is I have over 1000 items and I'm
trying to make it easier to fill in items and prices. How can I make this
more friendly. Thanks Musky
 
Musky

If your drop-down list is from Data Validation, you cannot have Autocomplete.

Try a combo-box drop-down list.

Debra Dalgleish has instructions.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP

I used V-LOOKUP to take an item from a drop down list and have it input a
price into a seperate cell, now the problem is I have over 1000 items and I'm
trying to make it easier to fill in items and prices. How can I make this
more friendly. Thanks Musky
Click to expand...

Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Lookup 1
Automatically filling a cell from a worksheet based on a selection 2
Data Validation 5
selecting from dropdown--have related info auto carry over 2
Data entered from list automatically enters number in another cell 4
resettable, over-ridable, default cell values 0
Vlookup issue 2
Create a drop down that adds up a price 1

Back
Top