Advanced Google Spreadsheet Search

[Andino_Gonzalez]

Hi, I have a question! I have a Google spreadsheet as my database. When I perform an advanced search in the spreadsheet, it only returns one result, and I have multiple rows associated with an ID. I mean, I have two veterinary clinics for one ID, and the search only returns the first result. Is it possible to change this?

Don't pay attention to the rest of the code, I'm just showing how I try to find a result associated with an ID:

result I get

what's in the spreadsheet:

Sorry for the English, I use the translator.

[Kevinkun]

your block image is low resolution, not readable. you need to upload a better one, and with language change to English.

[Idriss_Chrifi_alaoui]

[30Days/FREE] Advanced Google Sheets Extension 2025

Maybe this can help you

[Spicy_Topics]

The reason is you have used the local variable inside the for each items list so it will clear when it go to the second item of the result.

Put the local variable outside the for each item event and use the listview element set elements after the for each items in the result

This is not correct

This is correct

This is why it shows the second occurance only eventhough there were multiple