Indirect search criteria to dynamic list

I have a list of different configurations of sensors (different types of temperature, pressure, flow, etc). What I'm trying to do is if I type in a search cell, say A1, I would like to display the different types of configurations for that sensor. Not sure what this application should be, so I apologize if the title is sort of confusing. My guess is INDIRECT() may have some use to this application.

An example would be in A1, I would type "OAT" (for Outside Air Temperature), and the adjacent column to A1 would display all the temperature sensor configurations uniquely (no repeat temp configurations) to the search. An example of the temperature configurations would be "TempdegreesF - -32 to 240", "TempdegreesF - 20 to 80", "TempdegreesC - 0 to 100", etc. The raw data of all of the sensor configurations could be elsewhere. Not sure how INDIRECT() could associate "OAT" with "Temperature" with minimal helper/reference/tag cells.

I feel the only way to do this is create tags for each adjacent sensor configurations for each keyword I want to type in. Not sure how I would do that because it's backwards to what I know. If I do this, is there a way to create a dynamic tag for each search? Basically this database of sensor configurations will grow. The keywords to search for them will have very little growth. I may search "temp", "OAT", "ROOM TEMP", "Temperature", etc. but those are all somewhat all in the general category.

Hi FDibbins,

I attached a workbook with the result of what I'm looking for. I added notes in there as well to explain the groupings.
Book1.xlsx

Temperature. OAT is an acronym for for Outside Air Temperature. Temperature is the keyword for finding the sensor configuration in dealing with Temperature. In more general terms, if I typed in "Apple", I would like it to return all the different varieties of apples but the catch is "apple" is not concatenated with the variety names. So the result for "Apple" would be "Granny Smith", "Red Delicious", etc.

Yes. anything with temperature. However the search would be narrowed down based upon how exact the keyword/phrase is in the search box. If a sensor configuration was named "Temperature -40 to 370 degreeF" and I typed in "Temperature -40 to 370 degreeF". If I entered in "Temperature degreeF", the result would display all the sensors that display temperatures with units in Fahrenheit. If I entered in "OAT", "temp", "oat sensor", "oat temp sensor", they would display a very broad range of temperature sensors, but the search function would understand that it is referring to temperature for the sake of sensors. Other matching words will vary and perhaps be added upon.

Sensors in this discussion only monitor one specific thing whether that may be temperature, pressure, humidity, energy, etc.

I was afraid excel might think this would be too vague. My guess is I would add an additional column with each cell having tags delineated by a comma, or something else, to find the desired search results.