How to use the VLOOKUP function in LibreOffice Calc correctly

The VLOOKUP function is used to find the corresponding value of a specific value. It is constructed as follows:

Search criterion has to be the first column in the selection that is used for the array. Otherwise the formula will return #N/A.