How to use VLOOKUP in Microsoft Excel or LibreOffice?

How to use VLOOKUP in Microsoft Excel or LibreOffice?

Vlookup is very powerful function in Microsoft Excel. Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number.