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(H2,B3:E10,2,FALSE)
=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)

vlookup 1

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.

vlookup 2