I have an issue with google sheets where i have created a search function that will return a list of matching data, the issue I am having is that the data can not be edited from the returned results as its just a copy.

Is it possible to either edit the data from the returned results or click the cell and that can jump me from the selected cell to the data cell where i can edit the original?

I know this can be done just using the Ctrl F however the requirement is to have the search function at the top of the sheet locked as it will be years of sales data.

CodePudding user response：

an example:

=HYPERLINK("#gid=0&range=B"&MATCH(
 QUERY(A6:P42, "select B where B "&A1&" '"&B1&"'"), B6:B, 0) ROW(B6)-1, "jump")