Search Function on a Drop down list

AlexSGS

New Member
Joined
Aug 21, 2015
Messages
3
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?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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.
 
Upvote 0
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>
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top