Searchable cell - highlight results as you type your search
I wonder if it is possible but could I create a cell, that when I type value or text the results are highlighted ?
For instance: I have a file with moreover 500 products with each their own product number. Attached is an example. Some of the digits are the same with different letters which make the product numbers unique. Now my intention would be to create a cell. And when I type in that cell, result in product numbers are highlighted and the more you type in to that cell, the more the search gets narrowed down.
Below a simulation what I would like to achieve. It is not actual working !!! The highlighting (red letters) is done manually.
First example: I search for the combination "12" and I get 3 results.
Second example: I search for the combination "45" and I get 5 hits.
Third example: by keeping to type more into the search cell "NY145" I narrow my search down to 1 result.
I hope the three examples speak for them selves and that someone can tell me:
a) if it is possible
b) how to create it / what formula
Thanks a lot
MacBook Pro (2017 – 2020)