Search Function on a Drop down list

[AlexSGS]

Hi,

I've been searching for hours but have not been able to find something that matches exactly what I want to do so any help is much appreciated.

I design a costing sheet for our company which takes the cost price of a particular item and adds on costs for duty and freight based on monthly averages and then converts to desired sell currency to work out a selling price and adds margin etc.

My issue is when selecting the duty from a dropdown.

The dropdown source is a separate tab which has a list of generic products we sell and their respective duty charge percentage. I've run an INDEX/MATCH formula to pull this through based on the dropdown choice.

However, as there are so many items, I'd like to make it so my sales team can type in a few letters of the product they want to sell in the dropdown which will then populate the import duty % in the next column.

I added a combobox and have managed to get this search function to work for the first row. But I'm at a loss at how I can make this work for subsequent rows. For example a tender of 20 different products that need different duty rates selected based on the product.

I'm assuming the answer is I need a combobox for each row - however, is there any way to automate this?

 

[CalcSux78]

I'm not sure if I 100% follow, but sounds like you're looking to auto-complete entry within a dropdown, right? If so, you may use something from this page www.contextures.com/xlDataVal10.html

You could use the data validation methods described there to "Auto-Complete" the text that would be entered into the dropdown. Once an item from the list populates, it would retrieve the desired data for that selection.

Hope it points you in the right direction.

 

[AlexSGS]

Thank you for this. I downloaded the file on the link you provided and followed the instructions. It looks like exactly what I need - the combobox will appear upon double clicking a cell that has a data validation list in it.

Unfortunately my combobox is not hidden and will only apply to the LinkedCell that I enter in the properties. I'm not sure what I need to do to make it like the example

I want to use one combobox for every row in the column that uses the data validation list.

<a href="http://www.stooorage.com/show/3838/18513518_screenshot-excel-1.jpg"><img src="http://t1.stooorage.com/thumbs/3838/18513518_screenshot-excel-1.jpg" alt="18513518_screenshot-excel-1.jpg" border="0"/></a> <a href="http://www.stooorage.com/show/3838/18513519_screenshot-data-validation-source.jpg"><img src="http://t1.stooorage.com/thumbs/3838/18513519_screenshot-data-validation-source.jpg" alt="18513519_screenshot-data-validation-source.jpg" border="0"/></a>

 

[AlexSGS]

For now I am using a workaround that doesn't use a combobox. If anybody else has the same issue please see Youtube video: [h=1]Create a searchable drop down list in Excel
https://www.youtube.com/watch?v=vkPoViUhkxU[/h]