That table has 10,000 rows.
You have several possibilities …
- Look up the item directly in the online spreadsheet (if the spreadsheet keeps changing), or
- Load a Comma Separated Values (csv) or JSON download of the table from the Media folder and use a dictionary to map column 1 into column 2 if the table never changes.
- preload a SQLIte database in your app for fast lookup, using an SQLite extension.
Here’s the Google Sheets FAQ:
Look for a way to query your Google Sheets table in SQL using a LIKE clause, to shorten searches.
Here is my incomplete attempt to use SQLite for a lookup like this …
https://groups.google.com/forum/#!msg/mitappinventortest/LwJVNkyvPgU/vTaelFfzFgAJ