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.
read more