Vookup function in Excel

Vlookup is one of the Extensively used Excel function. It looks for the value in the Leftmost column in the Table array in Excel.

Syntax:

VLookup(, , , [RangeLookup])

Parameters:

  1. Ā lookupvalue – Value need to be searched in the Table Array
  2. TableArray – Contains the group of value
  3. ColumnIndexNo – Table array Column No where our reference value is found.
  4. [RangeLookup] – Takes two values true [approximate matching] and false [exact matching]

Example:

vlookupex

Keep Learning
Win Corporate

Website: http://www.wincorptrg.com
profile: http://www.urbanpro.com/bangalore/vijayalakshmi-g-m/626432

Advertisements