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.
Step 01
Select a value – that you want to search
Step 02
Then select a range for searching the value
Step 03
Then finally select the column no. To pull out information from that column.
Step 04
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 in Microsoft excel 2010.
Also, you can download the practice sheet from this given link
Click Here To Get File from Google Drive
Read Also:
How to hide columns rows with plus and minus button in Excel