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 function and formulasdget excelexcel formula isnaharvard business school cases for studentsiserror and vlookupms excel arraymba candidate resumeremove formula in exceldoing formulas in excelgaussian random number generatorexcel function randoffset example excelvlookup entire workbookhorizontal stacked bar chart excelbell curve formula excelvlookup range of numbersmicrosoft excel lookup functionexcel chart labelsbarchart futureexcel templates inventoryexcel vba if multiple conditionsdeduping in excelgraph points in excelexcel financial formulas cheat sheetbookstore uclavlookup meaning in excelucla ursaxls to pdf online converterwhat is a vlookup function in exceltypes of excel spreadsheetsadding macros in excelexcel vlookup function exampletick marks excelbruin bus hoursvlookup shortcutvlookup training videocreate line chart in excel 2010range of cells in excel formulagraph histogram excelexcel auto multiplyexcel random data generatorsegmented bar graph makerexcel shortcuts altinsert check mark in excelexcel macro databaseexcel macro to delete duplicate rowsinventory formula excelhow do you use vlookuplookup and reference in excelexcel if then formula with multiple conditionsmultiple if formulaslookup tables in excelcombine hlookup and vlookuphow to check duplicate records in excelms excel 2007 vlookuphow to find unique values in excelcreating a vlookupexcel vba tabexcel lookup tableucla student discountif statement excel examplesremove unique values in exceldelete row shortcut excelexcel drop down list vlookuphow to highlight a column in excelvlookup with formattingmatch function vbaucla ash centerwhat is a histogram in excelformula for excel sheetexcel vba range formulatutorial on vlookupdeloitte bta salaryexcel combine columnformat data labels excel