Learn how to use Excel’s most commonly used Function VLOOKUP, explained in the easiest way and also visually so that you understand it well!
Excel VLOOKUP Function searches for the value you specify and returns a matching value from another column. More technically, the VLOOKUP function looks up a value in the first column of the specified range and returns a value in the same row from another column.
For the reference, we will call above paysheet table as Report table. We want to retrieve Gross Salary (Column E) and Nationality (Column F) of by employee number (Column B) from another location which would be our Lookup Array or Lookup Table which you can find below:
For the references, we would call above table range as a Lookup table. From this lookup range or table, we are looking for Gross Salary and Nationality employee wise.
Lets see how VLOOKUP syntax is applied to our example. Below is step by step animation how VLOOKUP ‘s arguments flows:
From the above animation, we can see that what are the arguments with our examples. Please note that the first three arguments are compulsory and the fourth argument is optional which is the type of match we are looking for.
By default, VLOOKUP function applies 1 or TRUE or Approximate match (I will explain you Approximate matches and wildcards in another post). But we are looking for an Exact Match in this scenario, so we will be selecting either FALSE or 0.
Below is another image showing VLOOKUP Formula explained in both Report table and Lookup table to reinforce the formula syntax concept:
Video Tutorial from my YouTube Channel, Do not forget to subscribe my YouTube channel for excellent basic to advance Excel tutorials FREE!