what do you mean, you always have access to any row in the sheet from thunkable. in order to edit, you should setup your thunkable program to retrieve a row, provide input fields to allow data and entry and update that row in the google sheet.
my suggestion requires that you get your data from sheet3 not sheet1 - i think that’s what you meant. so you cannot easily update sheet1.
to do a search the way you want it, you can use the method suggested by @muneer - after you’ve mapped your DVL to your sheet , iterate over the DVL and if anything satisfies your required condition/s, set visibility of that DVL item to true else set visibiility to false.
see the method i suggested here:
maybe this method will work for you