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

is there a way to remove duplicates in excelexcel formulas referenceif cell is not blank excelwingdings excelvlookup falsestacked column chart excel 2010excel ifsexcel array tutorialexcel using countifadobe acrobat download cnetsymbol of tick mark in wordexcel copy formattingexcel common formulasfunny excel formulasexcel lookuprandom number generator in vbacalculate w4vlookup compare two listsvalue error in excel 2010excel power query examplesucla gpa scaleucla anderson mapvlookup 2 spreadsheetsexcel highlight duplicate cellsnormal distribution graph in excellookup function excelfind duplicates in an excel columnexcel formula namesexcel lookup not workingshortcut key for pivot table in excelvba averagems excel lookup function examplecheck tick symbollookup function excelexceljetinventory excel spreadsheetsites with most trafficvba excel templateninja notes reviewbins in excelexcel vba matchhow to insert tick symbol in wordcoding macros in excelvlookup formulasgaussian distribution in excelarray formula excel 2013copy formatting in excelvlookup multiple matchesworking at zs associatesexcel formula iserrorexcel using if statementshow to conditional format in excel 2013excel formula list with examples 2007excel compare two lists and return differencesrow heading in excelexcel identify duplicatesexcel formula sheetstacked columnucla anderson owaexcel comparison formularandom name generator pickereasy excel formula generatorvba multiple if statementshow to add a horizontal line in excel charthow to find out duplicates in excelsimple vlookupexcell modelshow do i do a vlookup in excelexcel sheet formulashow to convert xl to pdfexcell lookupexcel compare 2 columns for differencestwo way lookup exceltickmark symbolkeyboard shortcut for filter in excel