Skip to content

Instantly share code, notes, and snippets.

@apeckham

apeckham/sheets.txt

Created August 31, 2017 06:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save apeckham/c561a32dcbd85e2ba074611c4b872b76 to your computer and use it in GitHub Desktop.
Save apeckham/c561a32dcbd85e2ba074611c4b872b76 to your computer and use it in GitHub Desktop.
Download ZIP
sheets
Raw
sheets.txt
# vlookups to a different sheet
=ArrayFormula(IFERROR(VLOOKUP($A3:$A,INDIRECT("'" & B1 & "'!$A:$Z"),MATCH(B2, INDIRECT("'" & B1 & "'!1:1"), 0),FALSE
)))
# generate infinite dates
=ArrayFormula(date(2017, 8, 14) + row(A3:A) - 2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment