Search

Find Value

Last Updated: Mar 15, 2021

Articles

Use this function to find the address of a value in a worksheet.

Syntax

Find Value (id_or_url, sheet_name_or_index , search_value, private_key, cient_email)

Parameters

Input Parameter Name Description
id_or_url ID or URL of the Google Sheet
sheet_name_or_index Name of worksheet
search_value Value to find
private_key Private key of the service account
client_email Email ID of the service account

Returns

Return Value Description
Output
  • On Success returns 1, (Row, Column) of the cell having the value
  • On Failure returns 0, Error Message

Sample

Find Value (ABC123, Invoice, 3, —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—–, name@project-id.iam.gserviceaccount.com)

  • Uses the private key —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—– to connect to the Email ID name@project-id.iam.gserviceaccount.com, accesses the sheet Invoice using the ID ABC123 and finds the value 3.
    Returns the address (1, 2).

To view all the Google Sheets functions, click here.

Did you find what you were looking for?