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 to Use VLOOKUP Function in Microsoft Excel 2010
How it works
While you have a high volume of information in the excel sheet, definitely you might be falling into a situation for finding a 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 to 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 video, you can easily learn how to use vlookup function in Microsoft excel 2010.
Also, you can download the practice sheet from this given link