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

excel formulas 2007 with examples in excelhow to create a checkmark in excellogical tests excelcomplex if statements in excelexcel ifsexcel shortcuts in excelfind duplicates excel 2007if function in excel for multiple conditionsexcel binning datamicrosoft excel quick tipsexcel concatenate deutschhow to drag down a formula in excelhow to create histogram in excelputting formulas in excelexcel formulas meanthe goal bottleneckucla anderson deanhow to prevent duplicates in excelbin range excelvlookup to the leftnested if function exampleshlookup excel tutorialhow to create histogram excelvlookup formula in excel 2007how do you do a tick in excelvlookup returns 0excel planning calendar templateexcel cse formulausing vlookup excel 2010ucla gymhow to use hlookupsimulation examples in excelvlookup example between two sheetsline graph excel 2007shuffle namesvlookup with two conditionsassignment notebook templatehow to delete a pivot tablehow to make a bar graph in excel 2013excel lock formulaexample of countif in excelhow to display zeros in excelexcel count if formulaexcel find duplicate entriesexcel vba numberformatcompare columns excelcheckmark iconhlookup in excel 2010 with examplehow to draw a line chart in excel 2010excel clustered stacked columnbar line graph excelcreating a histogram in excelexcel 2007 compare two columnshlookup excel examplelogic statements in excelcomparing cells in excelgreater than excel formulaucla mba admissionsconjoint analysis excelnested ifs excelhlookup function in excelexcel vba formula in cellexcel rounding large numbershow to draw a line chart in excel 2010excel compare columns highlight differencesoffset function excel 2013how to remove duplicates from two columns in excelhow to count formula in excelall excel formulas in excel sheetwhat is meant by vlookup