Look Who it Was Random video

Excel - Mastering HLOOKUP: Navigating Horizontally Organized Data in Excel - Episode 1125

2,847 views · Published 19 October 2009 · 2:09 · Indexed 29 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Mastering HLOOKUP: Navigating Horizontally Organized Data in Excel.

Welcome to another episode of the MrExcel netcast! In this week's episode, we're diving into the world of HLOOKUP. Last week, we covered VLOOKUP and now it's time to tackle its horizontal counterpart. Are you ready to learn something new and expand your Excel skills? Let's get started!

So, what exactly is HLOOKUP? Well, the "H" stands for horizontal, meaning that instead of looking for data in a vertical column, we will be searching for it in a horizontal row. This can be useful when working with data that has been organized in a non-traditional way, such as across columns instead of down rows. But don't worry, with HLOOKUP, we can easily navigate through this type of data and find the information we need.

But what if you come across a table that is organized horizontally and you need it to be vertical? No problem! In Excel 2007 and newer versions, you can simply use the Paste Transpose feature to quickly switch the orientation of the table. Just select the table, copy it, and then go to the Home tab and click on Paste, then Transpose. Voila! Your table is now vertical and ready to be used with VLOOKUP.

But what if the table you're working with is constantly changing and you need a live view of it? That's where the INDEX formula comes in. By using the INDEX formula, we can create a dynamic view of the table, allowing us to see any changes in real-time. Simply select the range of data, use the INDEX formula, and specify which row and column you want to view. This is a great way to keep track of changing data without having to constantly update your formulas.

So there you have it, two different ways to work with horizontally organized data in Excel. Whether you use the Paste Transpose feature or the INDEX formula, you now have the tools to easily navigate through any type of data. Thanks for tuning in to this week's episode, we'll see you next time for another netcast from MrExcel!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Learning about HLOOKUP after last week's VLOOKUP lesson
(00:23) Understanding the concept of horizontal tables
(00:34) Using the Transpose function to fix a horizontal table
(00:44) Bonus tip: Creating a live view of a changing table with the INDEX function
(01:30) Clicking Like really helps the algorithm

This video answers these common search terms:
Copy and paste
Formulas
HLOOKUP
INDEX function
Live view
Pivot table
ROW function
Transpose
VLOOKUP


Don't use HLOOKUP...just turn the table back to a vertical table using the two methods shown in Episode 1125.Clicking Like really helps the algorithm

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152691/

More from this channel