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

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.