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.

Page Contents

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

Advertisement

About Mohammed Ahaduzzaman

He is a Founder and Freelance Writer @ BBA Lectures
MBA Articles and Zaman Accounting ! Blogging is his passion. He loves writing on Entrepreneurship, Finances, Accounting, HR, Digital Marketing, and other business issues. By profession, he is working as an HR Executive in MNC, but a blogger by hobby. By education, he is a Finance graduate, and continuing CS (Chartered Secretary) course under ICSB, Reach out >>> ahad406@gmail.com to connect for any queries on sponsored posts/affiliate marketing/any opportunity to grow together!

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.