[Andhy] Zero Zone

Vlookup in Excel

This is just a note for me, how to use vlookup in Excel.

Suppose that we had table with 2 column (name of football player with his club) as bellow :

And then we have another table with column football player and we want to know where the club for each player based on table given in the first table.

Than we should use vlookup function for this kind of comparison as bellow :

=VLOOKUP(E2;$A$1:$B$8;2;FALSE)

If we just want to know the name of player already listed on the first table or not, we can use the same function but we should change the col index num from value 2 into value 1.  So the function will be : =VLOOKUP(E2;$A$1:$B$8;1;FALSE)

Tutorial for vlookup can be found here

Tutorial for pivot can be found here