zakruti.com » IT - Software » Geeks Tutorial

How to Use the HLOOKUP Function in Excel

video description

Rating: 4.0; Vote: 1

you will learn how to use the HLOOKUP function in Excel. In this tutorial, you will learn how to use the HLOOKUP function in Excel. There are times when you want to calculate a value which resides in a separate table, but don't want to use IF commands for this. Lookups, vertical and horizontal, provide you with just the means to do it. In our example, we have our Horizontal Table in the same spreadsheet, but it could easily be in a separate one, or even in a separate workbook. As you can see, the table is an index of tax rates according to the offered salary. If such rules change along the way, we will need only to modify the Horizontal Table. Step 1. First, make sure the Horizontal Table is sorted in ascending mode. Then go to the first cell in the list that you want to calculate the lookup. Start typing: =HLOOKUP(the value you search in the index comma the horizontal table comma the indexable row, in our case the row of percentages) Step 2. Hit Enter. Excel will calculate the value by looking up in the entire Horizontal Table. Result: Congratulations, you have learned how to use the HLOOKUP function in Microsoft Excel
Date: 2023-07-08

← How to Use Offset Function in Excel

How to Use Symbols and Special Characters in Excel →

Related videos

How to Extend Windows 10 Support For Free (Enroll Now)

• Geeks Tutorial

Intel Arc GPU Driver Problems Revisited: 2025 Arc Graphics Driver Review

• Gamers Nexus

Windows Recall Is Too Risky, Turn It Off

• PC World

AM4 Lives: AMD Ryzen 5 5500X3D CPU Review & Benchmarks

• Gamers Nexus

Computing History: Exploring The TI-99/4A

• PC World

How to Find Any WiFi Password In Windows 11 (really easy)

• Geeks Tutorial

Comments and reviews: 3

John
all we needed was a one minute explanation on what parameters to use and you decided to do that part in a 1 second mumble then say you're done
reply

Robert
useless as teats on a boar hog.
How do you use it? Well you (skip the important parts) and you're done!
reply

David
Are we allowed to report this as Violent or repulsive content? I'm beyond repulsed of this tutorial
reply

Add a review, comment