Skip to content

Instantly share code, notes, and snippets.

@sbealer

sbealer/gist:8566395

Last active January 4, 2016 04:09
Show Gist options
  • Save sbealer/8566395 to your computer and use it in GitHub Desktop.
Save sbealer/8566395 to your computer and use it in GitHub Desktop.
Download ZIP
Using Query function in Google Spreadsheets. In this case, using a cell value for the condition. In this example you'll have a sheet named 2014_Q3. You're looking for a value where A = a cell in the current sheet (notice the &'s - Ampersands)
Raw
gistfile1.txt
=query('2014_Q3'!$A$2:$B$8; "select B where A ='"&A2&"' ")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment