What does the VLOOKUP in MS Excel function do?

Asked by Last Modified  

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

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

Microsoft Office

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

Science Freak

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

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

View 3 more Answers

Related Questions

What should I learn other than excel VBA training?
Excel VBA is a Very vast topic. Once you will start working on real life projects you will find your knowledge is always short. You can always learn VBA with Excel, Word, Powerpoint, Access, AutoCad, Soldiworks....
Vishal
What are some cool Microsoft Excel tricks?
there are 1000 of tricks that can be done in excel from basic to complex. but most awesome trick is to play old dosky games in excel, remember the child hood games like mario, boomerman , contra...
Shagufta
0 0
8
Is Advanced Excel Training necessary?
Yes, now days excel is very well accepted by most of the users from corporate, offices and even college students. They are learning excel. Excel can increase your work effectiveness. There are many functions...
Aditi
0 0
7

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

Ask a Question

Related Lessons

Shortcut of Excel for Selection
Select the whole column: CTRL + SPACE Select the whole row: SHIFT + SPACE Select table: SHIFT + CTRL + SPACE bar Select visible cells only: ALT + ; Select entire region: CTRL + A Select range from...

MS Excel: Formulas and Functions: Listed by Category
MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....

VBA Function - INSTR
INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...

SQL Join Types
There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

TAF Certificate Course!!
Hi, The TAF certificate provides students with a solid foundation in Four core areas: TAX ACCOUNTS FINANCE COMPUTER PROFCIENCY Highlights of the Course 1. ...

Recommended Articles

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 >

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 >

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 >

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 >

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