VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn.  While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it's still a good idea to learn this formula combination and Continue Reading >>
HLOOKUP is essentially the horizontal version of VLOOKUP.  The primary reason for using HLOOKUP in Excel is for when you have key data points arranged horizontally across the top of your table.  This usually happens when you are dealing with time series data; people have a tendency to list lookup values horizontally with this Continue Reading >>
The Complete Guide to Excel Lookup Formulas One of the most common tasks in Excel is the process of looking up specific values within a data set.  In a simple database, this process would be completed by writing a “query” for a specified “table.”  For Excel, you complete this task by using a “formula,” with specific Continue Reading >>

Related pages

the goal a process of ongoing improvement chapter summaryexcel vertical axisvlookup worksheetvba offset rowcan you find duplicates in excelcalendar template for excelucla statistics coursesexcel 2007 formulas listucla pre mbaexcel if statement syntaxsymbol excel formulainsert a check mark in wordsample excel macro codecharacter code for check marktranspose function in excel 2007different types of excel formulascheckbox in wingdingsucla gearinventory formulas excelp&l format in excelwingdings 2 downloadif function in excel for multiple conditionsucla course listingsif cell contains text then count 1excel formulas lookup and referenceuniversal studios tickets uclapivot table in excel shortcut keydelete duplicates in excelcomparison table excel templateexcel sampling distributionexcel graph distributiondeloitte consulting firmexcel hide functionediting charts in excelexcel vba lookuptick box symbolexcel look up functionsexcel lookup syntaxw4 allowances calculatorexcel random number generator no duplicatesvlookup will not workv look up exampleexcel macro builderhistogram chart in excelvlookup excel how tovlookup backwardstch worksheetshow to remove a formula in exceloffset match functioncreating histogram in excelexcel 2003 iferrorhow to create a stacked bar graph in excel 2010build histogram in excelhistogram graph in excelexcel macro matchmyculaiferror formula excelexcell shortcutsv lookup examplefinancial modeling excel shortcutsexcel stacked bar chartexcel drop down list vlookupduplicate formula in excelexcel vlookup tutorialhow to construct a formula in excelexcel formulas made easycheck for duplicates in excelexcel format cell formulaexcel vba matchchart labels excelexcel iserror vlookupucla bookstorehow to set up excel formulasexcel vba cell contains