Check if a value is in a list of elements (or an G. Sheets column)

You can combine this function with the combineAll function in order to check if one value is present in several columns

Video Example


  • value: The value to check if exists in a column

  • column: The column of items to search in

Expected Output

  • Boolean: True or False if the element exists or not

Text example

existsInColumn("JohnMu", A3:A6) 
// Column values: apple, banana, JohnMu, Cheese
// Returns True

Use cases

  • Check if a value is present in a column

Last updated