Vlookup (Vertical Lookup)
A Vlookup simply locates something in a range of cells and returns an item on the same row from a different column as defined by you.
Structure of a VLookup
=VLOOKUP(criteria, data range, Column to be returned, exact match?)
Criteria – The value you wish to be found in the data table
Data range – the range of data that is to be investigated
Column – the column from which you want data to be returned
Exact match – True (use if an appropriate match is acceptable), FALSE (use if exact match is required)
From the above example we can see that the only difference in the formula is that the column number has changed from 2 to 4.
By changing the value in the “Country” cell we get values returned for the appropriate country.