okey, we know that excel has a lot of helpful function which will beautifully make our tasks much easier (or better to say more efficient). One of those is the “vlookup” function.
#well, actually, i’m being asked about “vlookup” function, and i think it’s better to put it here.
Then, how we use it?
When you have series of data (array) or table and for certain purpose you want to “re-call” a data to another table, for example (see figure above), you want to know the data from number “5” (red arrow) and it’s paired (blue box), you only need to type “5”, and the related data will showed up. ^_^
The formula for vlookup is: ” =VLOOKUP($A18,$A$3:$F$15,D3,FALSE)”
the general formula is : “=VLOOKUP(lookup cell, table array,column index number, range lookup)”
see the figure below:
or this one :
Hope it helps.
(my current daily tagline) 😀