Google-sheets – Search a Google Spreadsheet and return results that are ‘clickable’ that takes you to the sheet and row

This is done by vlookup. A basic example is

=vlookup(B2, Sheet2!B2:C, 2, False)

which says: find the value of B2 in the first column of the range Sheet2!B2:C, and return the corresponding value from the 2nd column of that range. (The last argument, False, says the searched range need not be sorted, and exact match is required.)

A more advanced version, for looking up all students at once:

=arrayformula(iferror(vlookup(filter(B2:B, len(B2:B)), Sheet2!B2:C, 2, False)))

Additional elements here:

• this is an arrayformula, which processes lookups for an array of data
• the array to process is B2:B of the current sheet, but it's filtered so we don't waste time looking up empty-string values
• the wrapper iferror suppresses error messages #N/A when no match is found; the Quiz score cell will be blank if the student never submitted the quiz.

I have very little information to work on. I'm assuming you have the "category code" in a different column for the row entry. "Addition sheet" means you want it in different tab of same spreadsheets. You can use this code in your cell from where you want to start printing the rows

=Query('<Sheet name>'!<Column Range>,"Select * Where <column> = '<category code value>'")

Suppose Sheet name is Sheet1, Column range is A2:Z, column with category code is B and category code you're looking for is "Medicines".

=Query('Sheet1'!A2:Z,"Select * Where B = 'Medicines'")