Enter code into a dropdown list, bring back results

NOTE: Sorry I entered drop down list in the title, I meant search box.



So I have a large list of data, e.g a code and products associated with the code (one code can have many products).

What I want to do is create an excel sheet where I have a front page, the user can type in a code and then hit a button and the relevant product codes/ details are returned.

I've had a look at index fnctions which will give me multiple results for one code. One thing though is that I want the results to appear once the user has entered the number and then hit a button.

What would be the best way to go about this?

Any help would be great.

Thanks

Hi thedon_1,

you have guessed it right... Index - Match array function can be used here with some help of other functions like small / row / if. After this formula can be refreshed with a click of a button. Would suggest you to upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>