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

how to analyze a case study harvardinventory templates exceldecimal placementshow to delete a cell in excelexcel sum vlookupshortcut key of filter in excelhow to remove conditional formatting in excelsimulation excel examplenested vlookup in excelexcel financial formulas cheat sheetucla ackerman unionhow to delete duplicates in excel 2013check symbol in ms wordexcel quotes in formulahide excel formulasxls to pdf online convertervlookup returnmba calculatorexcel formula syntax cheat sheethomework trackerexcel formula find duplicatesv lookup h lookup pivot tableadobe pdf download cnetiserror vlookupchart template excelprobability histogram generatorbruinbus uclaexcel random integerhow to construct a normal probability plot in excelucla anderson alumni databasedelete row shortcut excelvlookup excel vbaestimating spreadsheet templateonline histogram graph makerbell curve generatorexcel line graph tutorialexcel error checkingsymbol tick boxpay stub excel templatevlookup formula to compare two columnshow to draw bell curvehow to de dupe in excelexcel v look upstudent database xlsexcel unique numbersusing macros in excelcomplex graphs in excelshortcut for checkmark in excellookup functions in excelhow to make a column graphhow to use hlookupexcel hlookup functionconsulting boutiqueslabel chart excelcreate macros in exceloperational bottleneckformula for vlookupif statements in excel 2010excel lookup stringexcel sort ascendingpay stub creator excelhow to copy formatting in excelhow many columns and rows in excel 2010match formula in excelsymbol for tick in excelhow to write excel macrosexcel 2010 remove duplicate rowsexample of hlookupnested if vba excelhow do you remove duplicates in exceltick in wingdingscolumn and line chart excel 2010inserting check mark in excelexcel stacked line chartmyucla housingthe goal by eliyahu m goldrattmultiple if formulas