Create a list of companies based that match dropdown selection

I am new to ExcelForum. I have the attached excel spreadsheet of 150 semiconductor design companies that design one chip or a combination of 40+ chips. I would like to be able to have a easy way for a user to be able to list companies that design a selected type of chip by using something like dropdown list of types of chips that will generate a list of companies that design that type of chip. My ultimate goal is to put this online on a webpage that will allow a user to list companies that design microprocessors for example (e.g., AMD and Intel).

A drop down list is useless for this.

use a text box linked to a listbox instead.

Simplest to do in Userform.

But it can be done on a work sheet.

BRB

Ok

I have created something to get you started.

Enter "Cis" and press enter into cell A2 in sheet "Search". The listbox will be populated with all entries that contain Cis in column K.
Too many entries to be useful.

Type PM in cell B2. The listbox will be populated with all entries that contain both Cis and PM in column K. Two Entries.

Type Ana in cell C2. The listbox will be populated with all entries that contain Ana, Cis and PM in column K. One Entry.

Selecting any entry in the Listbox will cause the entry to be saved in the range E2 to G2.

There are three Macros involved in this.