Database Theory

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 >>
When deciding between which vertical lookup formula to use, the majority of Excel experts agree that INDEX MATCH is a better formula than VLOOKUP.  However, many people still resort to using VLOOKUP because it’s a simpler formula.  One major driver of this problem is that most people still don’t fully understand the benefits Continue Reading >>
VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel.  This tutorial assumes you already have a decent understanding of how to use VLOOKUP.  If you do not, please click here for a beginner’s tutorial on VLOOKUP. Objective VLOOKUP MATCH is an improved variation of your basic VLOOKUP or INDEX MATCH Continue Reading >>

How to Use VLOOKUP

by Matthew Kuo on December 19, 2012

in Database Theory, Excel

For most Excel users, VLOOKUP is the first complex formula they learn.  Performing a lookup is an extremely valuable function for any situation where you’re dealing with large data sets.  While the VLOOKUP function itself has become somewhat dated, as there are other better alternatives such as INDEX MATCH, it is still important 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 multiple if statementcount columns excelexcel vlookup true falsems excel advanced tutorialexcel vlookup function examplede dupe exceldifference between rows and columns in exceloffset formula in excelexcel replace duplicates with blankstick for microsoft wordexcel 2010 stacked bar charthow to add chart title in exceldifference between sorting and filtering in excelexcel formula cheat sheet pdfexcel formula creatorlookup functions in excelbar diagram in excelworking with arrays in excelcreate histogram in excel 2013shortcut key for excelhow to convert excel file to pdfcount command in excelcustom cell format excelwww myuclaexcel vba minimumprimo pdf converterexcel macro codeabout excel formulas with examplename picker for contestuse of offset function in excelhow to draw a horizontal line in excel graphmicrosoft excel vlookup functionmeaning of isnahow to find duplicate entries in excelvba offset selectionexcel formula remove duplicates2015 w 4 withholding calculatorhistogram in excellhow to check excel formulasmacro remove duplicatesfind duplicate lines onlinevlookup excel macconditional vlookup in excelwingdings character codesvba vlookup codehlookupshomework agenda templateirs tax estimatorlookup a value in excelexcel 2010 how to remove duplicatesrandom number generator in excel 2010accounting formats in excelucla requirements gpahistogram builderfemba uclanested if function excelsales forecasting excel templatevba excel macro examplesinsert check mark symbol in wordhow to put tick mark in excelexcel stacked chartsmultiple vlookupsindex and match multiple criteriawhat is vlookup on excelhow to create a vlookup in excel 2010vlookup codeexcel compare two columns find differencesexcel function vlookupassumption mbaexcel function and formulashow to insert tick mark in wordremove duplicates excelvba nested ifexcel column headingssimple excel commands