Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

How to Use VLOOKUP Function in Microsoft Excel 2010

Share Post @

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.

Step 01

Select a value – that you want 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 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

Click Here To Get File from Google Drive

 

Summary
How to Use VLOOKUP Function in Microsoft Excel 2010
Title
How to Use VLOOKUP Function in Microsoft Excel 2010
Description

How to Use VLOOKUP Function in Microsoft Excel 2010

Show Buttons
Hide Buttons