VLOOKUP(...)
How excel's VLOOKUP() works.
Used Functions
Category: Lookup and reference
Looks in the first column of an array and moves across the row to return the value of a cell
Syntax
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Practice VLOOKUP Formula at Sheetzoom
VLOOKUP formula at Microsoft helpCategory: Lookup and reference
Looks up values in a reference or array
Syntax
MATCH(lookup_value, lookup_array, [match_type])
0
The working of formula of VLOOKUP() is based on looking for the lookup_value in extreme left column. The second argument it takes is lookup_table, the third argument provides column to get the values from, here the MATCH() function can be replaced by a integer, but this MATCH() function makes more flexible to use. The last argument is used to get an exact match.