Search more than one column in a Google Sheet

Continuing to discuss the issue, see this example

This is my data set in sheet1
image

I go to another sheet (sheet2) and create the same columns with additional search column
image

In the first row and first column of the data enter this formula

=filter(Sheet1!A2:B7,Sheet1!A2:A7=C2)

This means that Google sheet will regenerate the list in sheet2 that matches the text entered in the search column.

In Thunkable you can place a Text Input and update that row/column in Google sheet to get the filtered value which is mapped to the DVL (Data Viewer List) in your Thunkable screen.
image