Monday 3 August 2015

Excel - VLOOKUP Easy Explanation

To build a VLOOKUP, you need 4 parameters

·        First parameter of the function contains a value you want to search.
·        Second parameter is the range of cells where you want to make your research.
·        Third parameter indicates the column number you want to return.
·        The last parameter is 0 or FALSE (means exact match) or 1 or TRUE (means approaching).




No comments:

Post a Comment

Contra entry example

Contra Entry :- If a transaction requires entries on both the debit and the credit sides simultaneously, it is called 'Contra entry&...