Thursday 26 January 2017

How to do vLookup?

VLookup step by Step:



1. Vlookup is a special feature of Excel.







2.VLookup is the function that allows you to find the data vertically from left to right.


3. First find the data table.



4. Want to Find the value of "C" in the another location.




5.  Find the value of "C" using vLookup.


6.Fill the formula based on the below instructions.

7. The Formula is,


8. The final result should be like below.


9. If any queries type in commands.