Search Functionality or search Button

[Howardc1001]

I have sample data on sheet1 and have a summary sheet where I have set up a data validation list

I would like to set up a search button or some type of search functionality that if I type for eg shirts it will select the drop down validation list


I have attached sample data with a few item, but the list could have 150 -200 items so that if one selected the drop down without a search button or search function, it will be cumbersome


It would be appreciated if someone could assist me to set this up

[azumi]

If yoy have data validation on B1, put this on B3 for "Items":

=IFERROR(INDEX(Sheet1!$A$1:$A$10,MATCH(B1,Sheet1!$A$1:$A$10,0)),"")

For "Values", put on C3:
=IFERROR(INDEX(Sheet1!$B$1:$B$10,MATCH(B1,Sheet1!$A$1:$A$10,0)),"")

[Logit]

.
Your description is not clear. Please be more specific where the drop down is located (none found at this point).

And are you saying you want to search the drop down list, because there may be a total of 200 items in that list and you don't want the user
to have to scroll down through it to find the term they are seeking ?

Are you only wanting to search the drop down ? Or does finding the term you were seeking initiate something else ?

[kvsrinivasamurthy]

you want drop down list by typing Shirts any where in the sheet or in a specified Range . For Eg B12:F30.

[Howardc1001]

Thanks Azumi for your input

[Howardc1001]

what I am looking for is to have a search button, where I can type in for eg shirts in say B1 and it will be linked to the drop down button per the data validation list

[Logit]

.
There is no need for a Command Button to act as a search feature. Here is part of the formulas :

Please Login or Register  to view this content.

Review the attached workbook for the remainder of the formulas and layout.


azumi has an effective approach to your goal as well.

Overall if you are wanting to use a command button to activate a search function, you should not be using the drop down feature.
There are other means to search for your term/inventory level without the drop down.

[Howardc1001]

Thanks for the help

[Logit]

.
You are welcome.