What does the VLOOKUP in MS Excel function do?

Asked by Last Modified  

5 Answers

Learn Microsoft Excel Training

Follow 0
Answer

Please enter your answer

Tutor

Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.
Comments
Dislike Bookmark

It's used to Lookup data vertically. you can ping me if you want to learn deeply.
Comments
Dislike Bookmark

Microsoft Office

This is Vertical look up of data method other is H look up horizontal look up of data
Comments
Dislike Bookmark

Science Freak

It allows to find particular words as mentioned by us in the function in a vertical selection of cells
Comments
Dislike Bookmark

VLookup helps to lookup for a value in a table and return the required column from the table. For more info, please contact us. Thanks, Team Excelytics Ameerpet, Hyderabad.
Comments
Dislike Bookmark

View 3 more Answers

Related Questions

How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.. within minutes it should come in my mind what code i have to write for this situation...I know its not that easy.. but I feel that its not hard too. I need advise as to what I have to do.. Eagerly waiting for the encouraging responses from all the teachers& trainers..
You need to understand the grammar of VBA Language first like collections ,objects ,methods and properties,syntax of different objects and their uses etc ..Once you are clear with these concepts ,you can...
Sandeep
Excel formulas in advance level?
In excel we have lot of staff and formulas, we can learn based on your requirement, in excel vlookup, hlookup, pivot table if condition, sumif ifs, countA, if ifs, data validation, etc. and we have to...
ManojGS
What is the use of Format painter in MSExcel?
In Microsoft Excel, the Format Painter is a tool that allows you to quickly copy formatting from one cell or range of cells and apply it to another cell or range. It helps you maintain a consistent...
Kirthi
0 0
5
How to write square in excel?
Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript
Dharmendra
0 0
9

Hi All,

My question is how to define age calculation in excel by formula?
Enter DOB in one cell. For example in Cell A1. Then in the cell where you want to calculate Age there write as =(TODAY()-A1)/365.25 .25 has been added to the 365 because to accommodate the leap year days in between.
BINAYAK

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Be prepared to get trained--init
Before starting the training,students must be mentally prepared for acceptance of new knowledge. Students must attend training with open minded forgetting the position they are working.This will help...
S

Smartnub Softsolutions

0 0
0
Concatenate Function
Concatenate , one of the text functions, to join two or more text strings into one string. The Excel Concatenate function joins together a series of supplied text strings or other values, into one combined...

Saburudeen Ma

0 0
0
Excel Keyboard Shortcuts
Our day to day work involves excel and to complete our work fast we should have adequate knowledge of keyboard shortcuts. I am going to give you simple but useful tip which will helps you to navigate excel...

Gaurav C

1 0
0
Excel Tip 1: VLOOKUP to pull left column values
Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...

Karthik Dale

0 0
0
Tips - How to put PivotTable Field List back at its Original Position?
Have You ever struggled to put PivotTable Field List back at its Original Position?*Original Position - right-side of the worksheet, as highlighted in the following picture: If Your answer is Yes, You...

Ankur Sharma

2 0
1

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you