What is the HLOOKUP function, and when should it be used?

Asked by Last Modified  

1 Answer

Learn Microsoft Excel Training

Follow 1
Answer

Please enter your answer

Sudha R

Computer Faculty in CBSE School with 17yrs experience

The HLOOKUP function is useful for looking up values in tables where the data is organized horizontally. For example, you could use the HLOOKUP function to look up the price of a product in a price list, or to look up the population of a country in a table of population data. Here is an example of...
read more
The HLOOKUP function is useful for looking up values in tables where the data is organized horizontally. For example, you could use the HLOOKUP function to look up the price of a product in a price list, or to look up the population of a country in a table of population data. Here is an example of how to use the HLOOKUP function: =HLOOKUP("Apples", A1:F3, 2, FALSE) This formula will look for the value "Apples" in the first row of the range A1:F3 and return the corresponding value in the second row of the same column. The HLOOKUP function is a powerful tool that can be used to save time and improve the accuracy of your spreadsheets. If you find yourself frequently looking up values in tables, the HLOOKUP function is a valuable tool to learn. read less
Comments
Dislike Bookmark

Related Questions

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything in the range which are in - in a colour and positive in one single colour. How can that happen so can anyone please help me on it?
1. First you have to select the range of cells where you want to apply conditional formatting 2. You have to select conditional formatting from Home tab in Excel window 3. There will be many categories,...
Charan
What is Microsoft Excel?
It is an Application which consist of Spread Sheet for creating Document based on requirement
Swati
0 0
5

Make A Excel Software Challenge: To Track Time Records To Enhance Daily Output Of Staff
Through Time Sheets
Bikram Jeet
0 0
7
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
What is shortcut to rename the spreadsheet name?
Alt+H+O+R
Umang

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

Ask a Question

Related Lessons

Formula to Populate Weekdays of a Given Month
If you want to populate weekdays (Monday to Friday) in a range, follow below steps. Step1: In Cell A1 write any month 1st date. Let’s say 02/01/2017 (Feb 1st 2017) Step2: In Cell C1 write this...

Karthik Dale

0 0
0
SQL (Structured Query Language)
SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL...

Itech Analytic Solutions

0 0
0
Create a Grading in Excel using Formulas (All versions)
Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

Bhavna Philipose

0 0
0
Excel Tip: Use Index Or Match Instead Of Vlookup Or Hlookup.
Hi, In today's Excel topic we will see how Index & Match function is superior than Vlookup/Hlookup. With Index and Match, the return value need not be in the same column as the lookup column, unlike...

Karthik Dale

0 0
0
Benefits Of E-Learning
From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...
E

Edusmart Skills

0 0
0

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 >

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 >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

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 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 Noida
Microsoft Excel Training classes in Kolkata
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