Use this function to find all occurrences of the provied value in a worksheet.

Syntax

Find All Values (id_or_url, sheet_name_or_index , search_value, private_key, cient_email)

Parameters

Returns

Sample

Find All Values (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 occurrences (1, 2), (2, 3) .

To view all the Google Sheets functions, click here.