How to Use VLOOKUP Function in Microsoft Excel 2010
How to Use VLOOKUP Function in Microsoft Excel 2010. Basically , vlookup is a very strong and useful function that we found in Microsoft excel as well in 2010.
How it works
While you have a high volume of information in excel sheet , definitely you might be falling into a situation for finding specific list of information. Yes; happy to say that you can easily do this by vlookup function. It saves your valuable time.
Suppose you want to segregate the whole calculated salary among cash and bank account holders then this function will work for you as a rocket.
Select a value – that you want search
Then select a range for searching the value
Then finally select the column no. To pull out information from that column.
In a nutshell just put 0 after mentioning column so that n/a will appear on results if value not found in a range.
In this vedio you can easily learn that how to use vlookup function in Microsoft excel 2010.
Also you can download practice sheet from this given link