How do I search Google Spreadsheets?
Unfortunately there is no searching functionality in the Spreadsheet services. You can get the data for the range you are searching on, and then iterate over it looking for a match. Here’s a simple function that does that: /** * Finds a value within a given range. * @param value The value to find. * … Read more