Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Use the HLOOKUP Function in Excel. That video is uploaded by Excel, Word and PowerPoint Tutorials from Howtech at 2013-08-08T15:00:20-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [iiu-GtBkAuk]
| Name | How to Use the HLOOKUP Function in Excel |
| Video Uploader | Video From Excel, Word and PowerPoint Tutorials from Howtech |
| Upload Date | This Video Uploaded At 08-08-2013 22:00:20 |
| Video Discription | In this tutorial, you will learn how to use the HLOOKUP function in Excel. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ 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. iiu-GtBkAuk |
| Category | Howto & Style |
| Tags | horizontal lookup function | hlookup | hlookup in excel | hlookup excel 2010 | how to use hlookup in excel | horizontal lookup | excel hlookup function | using hlookup in excel | use hlookup | formula | document | office | excel | excell | exel | how to excel | excel for beginners | office 2010 | MS | microsoft | microsoft excel 2010 | excel 2010 tutorial | microsoft excel tutorial | excel formulas | excel 2010 | excel 2007 | excel help | excel tutorials | tutorial | video | howto | how to | howtech | guide | manual |
