This tutorial uses a shopping application to show the way Vlookups are used. All material shown here applies to Excel, Libreoffice and openoffice.
The Vlookup requires four parameters:
This is the element you wish to have looked up
This is your look-up table, your dictionary so to speak
Column number of element you wish returned
Input is either 0 or 1
Does the dictionary contain all elements you wish looked up? Then you enter 0
If the dictionary only contains ranges, then you input 1.
Please use the feedback link below for comments and suggestions.