LibreOffice / Excel: Use tables like a hash map in formulas with VLOOKUP

Posted . Visible to the public.

If you're a frequent user of LibreOffice, I strongly recommend to checkout out the VLOOKUP Show archive.org snapshot function (SVERWEIS in German). It allows you to treat a column pair as a hash map, where you lookup keys in the first column and return values from the second.

Henning Koch
Keywords
SVERWEIS, OpenOffice
License
Source code in this card is licensed under the MIT License.
Posted by Henning Koch to makandra dev (2015-05-03 11:33)