Skip to content

Instantly share code, notes, and snippets.

@theodorosploumis

theodorosploumis/libreoffice_left_join_tables

Last active August 29, 2015 14:11
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 theodorosploumis/8c0d8f6e481aa6a12c8d to your computer and use it in GitHub Desktop.
Save theodorosploumis/8c0d8f6e481aa6a12c8d to your computer and use it in GitHub Desktop.
Download ZIP
LibreOffice left Join Tables using unique id
Raw
libreoffice_left_join_tables
// INDIRECT (Turns text into a range, if that range is valid)
// MATCH (Returns the relative position of an item in an array that matches a specified value. The function returns the position of the value found in the lookup_array as a number.)
=INDIRECT("SheetName.G"&((MATCH($D2;SheetName.$A$2:$A$103;1)+1)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment