Creating a Search Box

[Mazzaaa]

Hi All,

i am working on a purchasing management database, and have set up the spreadsheet for ease of use for me colleagues, i want to add a search box at the top but dont know how to go about it.

what i want is a search box that allows the user to enter and information, if it matches the information in the table below, to find and go to that information.

i have attached my worksheet for you to have a look at....

i would like the search box to be in F2.spreadsheet1.xlsx

[JohnTopley]

What exactly do you require in this "search box"??

Or this an Excel 2016 feature? (I only have 2010).

[Mazzaaa]

when someone fills in the search box, itll then look through the table below and find anything that matches within the product column