Skip to content

Instantly share code, notes, and snippets.

@hansgafriedzal

hansgafriedzal/gsheet-left-vlookup-first-non-blank-cell.txt

Last active May 17, 2018 08:40
Show Gist options
  • Save hansgafriedzal/7f06f3049b600800967987a2f9214555 to your computer and use it in GitHub Desktop.
Save hansgafriedzal/7f06f3049b600800967987a2f9214555 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gsheet-left-vlookup-first-non-blank-cell.txt
=index(A:B,match(+filter(B:B,B:B<>""),B:B,0),1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment