What is VLOOKUP & HLOOKUP?

Asked by Last Modified  

1 Answer

+1 Microsoft Excel Training

Follow 1
Answer

Please enter your answer

Altaf Karimi

Microsoft Certified Trainer

Dear Geet, these are 2 most useful functions of MS Excel. V is vertical and H is horizontal. The purpose of the function is to extract the value based on common data from any other data - that data may reside in the same sheet, any other sheet or any other workbook. Hope you get some idea about it :)...
read more
Dear Geet, these are 2 most useful functions of MS Excel. V is vertical and H is horizontal. The purpose of the function is to extract the value based on common data from any other data - that data may reside in the same sheet, any other sheet or any other workbook. Hope you get some idea about it :) All the bestt read less
Comments
Dislike Bookmark

Related Questions

can i teach
For teaching two things are must 1) you must have sound knowledge of the topic 2) then you must know the art of teaching. You should teach in a such a way that you are able to make people understand...
Abdul
How do I delete a worksheet in MS Excel?
By default, Microsoft Office Excel provides three worksheets in a workbook, but you can insert additional worksheets (and other types of sheets, such as a chart sheet, macro sheet, or dialog sheet) or...
Khushbu
How do I rename a worksheet in MS Excel?
Double click the worksheet name, then replace the existing name with a new name and press the enter key
Dhanshri
1 0
7
How do you deal with large data sets in Excel?
if data rows are greater than 10L then u will use MS. Access
Ajay
0 0
5
How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Ankita
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

Hide Duplicate Values & Apply Borders Using Conditional Formatting
Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

Ankur Sharma

1 0
0
Hidden Gems Of MS Excel - Track All Comments At Once OR Delete All Comments At Once
*this Article is about Comments in MS Excel, NOT NotesClick here to Learn difference between Comments and Notes You have added many Comments on a Worksheet.Now, You are unable to track All Comments....

Ankur Sharma

2 0
0
Arrange and View Multiple Worksheets at Once in Excel
Arrange and View Multiple Worksheets at Once in Excel This feature allows you to view multiple worksheets at once from the same workbook at the same time. You need to follow beneath simple...

Vishesh Golya

0 0
1
Learning excel complex function by using simple steps
Step 1: Understand and practice the individual excel functions thoroughly Step 2: Split the problem statement into N number of small pieces. Step 3: Use individual functions to solve the small piece...

Umasankar Natarajan

0 0
0
Exploring Excel HLOOKUP Formula
Let's break down HLOOKUP in detail. What is HLOOKUP? HLOOKUP (Horizontal Lookup) is an Excel function that searches for a specific value in the first row of a table and returns a value...
G

Ganesh S.

0 0
0

Recommended Articles

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 >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

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 >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Bangalore
MS Office Software Training in Mumbai
MS Office Software Training in Hyderabad
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you