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

editing graphs in excelexcel vba range functionstack chart in excelucla gpa averagetrue formula in excel 2010what is the bin range in a histogramdata duplicacyindex and match function in excelhow to use excel lookup functionvlookup across worksheetsrun macro without opening workbookwingdings 2 fontnested if functions excel 2010ucla mba coursesvlookup two conditionsgaussian curve formulahow to make a line chart in excel 2013countif excel greater thanfree primo pdf converterexcel all formulas with example 2007word insert tickexcel check for duplicatesexcel histogram binv lookup on excelhow to insert a total row in excelfinding duplicate in excelvlookup function examplesucla gear cheapbell curve in statisticsinsert tick box in excelhotkeys excelexcel insert shortcutstack graph in excelucla health storehow can use vlookup in excelcheckmark for powerpointvlookup in excel 2007pivot a table in excelexcel if statements exampleslabeling graphs in excelhlookup and vlookup in excel 2007 with examplecreative excel chartshow to insert a total row in excelisna formula in excelexcel formulas with examples in excel sheetxcel shortcutswebmail.kinross.commulti column vlookupwhat is a vlookup functionvlookup errorexcel chart labelexcel file converter to pdfcheckmark for excelvlookup formula explaineddelete duplicate entries in exceleasy way to find duplicates in excelexcel formula rowexcel custom format codesexcel shortcut filterms excel vlookup exampleshighlight duplicate rows in excel 2010how to dedupe in excel 2010excel lookup formulaisna functioncomplex excel formulas with exampleswhat is the use of pivot table in excelexcel insert shortcutexcel vba offsetexcel vba vlookup formulahow to find duplicates in 2 excel spreadsheetshow to randomly generate numbers in exceldefinition of vlookup in excel 2007excel insert shortcutucla mba admissionsputting formulas in excelhlookup syntaxformula filter excel