How to implement search in Google Sheets?

Question

Google Apps Script

Perhaps someone has already organized something like this or have thoughts on how to do it. There is a Google Spreadsheet, it has two sheets (both sheets are identical, one is active, and the other is created to archive data from the first one). The first sheet is filled with employees - in column B the position of the goods is entered by one manager, in columns C, D, E its characteristics are entered by another manager. It is necessary to implement a search on column B, that is, when the first manager starts adding any position to column B, the "search" should check all rows that are higher in column B + column B in the second sheet (which is the archive) and if there are matches, show this option to the manager (important! with characteristics from columns C, D, E). Ideally, the search should work using regular expressions, that is, the position regardless of spaces, hyphens,

PS The task is complex, I don’t hope for any ready-made code, if you have any thoughts, please write at least functions / methods through which this can be implemented, there will be at least a direction where to "dig")

Answer 1

If you want to write it yourself, study the documentation , what else can you advise.
1. Get the active row number
2. Get data from another sheet before the active timeline.
3. Go through the data and find what you need.
4. Write all this in a simple onEdit trigger
Find a developer, it is unlikely that someone will write code for a formalized task for you.
---
Maxim Stoyanov (stomaks), developer of Google Apps Script .
g-apps-script.com
stomaks.me

Answer 2

Hints can be implemented, but only on values ​​from one column. I will prompt, for each new line it is necessary to form the drop-down list. Note that it is limited to 500 values. The rest is only on the front, in modals or sidebars.