Things you should know about VLookUp

--->> VLookUp is a function to lookup and retrieve data in a table.
The "V" in VLookUp stands for 'Vertical'.

* VLookUp value should be appear in the left most column.
* The data you want to retrieve can appear in any column to the right.
* When we use VLookup imagine that every column in table is numbered, starting from left.To get a particular column as column index.

Syntax of VLookUp: Contains four arguments

VLookup(LookUp_Value,Table_Array,Column_Index,Range_Lookup)

    1.The value you are looking for (lookup_value)
    2.The range of cells that make up the table (table_array)
    3.The number of the column from which to retrieve a result (column_index)
    4.The match mode (range_lookup, TRUE = approximate, FALSE = exact)

--->> VLookUp looks only right to retrieve data.
--->> VLookUp always finds first Match
--->> VLookUp is not case-sensitive

Source: https://exceljet.net/things-you-should-know-about-vlookup and