Hi Community - new to App Sheets
I have a two column spreadsheet with a serial number in column 1 and a model number in column 2.
I want to create a search app.
User will enter either the serial number or phone number and the app will generate the corresponding value from Google sheet.
So if the user put is in the serial number the result will show the model number and vice versa.
Expect approximately 5,000 entries per column.
Can this be done?