Lookup & Reference

Home/Excel Formulas/Lookup & Reference

Excel Lookup & Reference Functions:

Explained with Examples.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

  • OFFSET: OFFSET is a Logical Function. OFFSET formula is very useful to travel in the Worksheet and fetch a specific range from particular Cell or Range. 
  • COLUMN: COLUMN is a Logical Function. COLUMN Function in Excel returns the column number of the given reference
  • ROW: ROW is a Logical Function. ROW Function in Excel returns the row number of the given reference.
  • CHOOSE: CHOOSE is a Logical Function. Choose function helps us to select a particular value from list of values. Or selecting particular cell or range from a range.
  • INDEX: INDEX is a Logical Function. INDEX Function in Excel returns either the value or the reference to a value from a table or range.
  • MATCH: MATCH is a Logical Function. MATCH function is just opposite to Index Function. Index returns a match value for a given index from the range.
  • HLOOKUP: HLOOKUP is a Logical Function. HLOOKUP is helpful to get the values from the lookup range, it search from top to bottom in Horizontal approach.
  • VLOOKUP: VLOOKUP is a Logical Function. VLOOKUP looks for the lookup_value in vertically in a given array and results the respective value from the specified column.
  • LOOKUP: LOOKUP is a Logical Function. LookUp function is helpful if you want to look up a value in either in one-row or one-column data range or any array.

Related pages

data control language in sql with examplehow to vlookup in excel 2007wizard in excelwhile loops in vbaunhide first column excelmatching cells in excelvba code to export access table to excelexcel visual basic macrovba save pdfunprotect excel workbook onlinehow to create workbook in excelexcel how to change rows to columnsloops in vba excelvba combobox additemlook up function in exceltypes of charts in spreadsheetsas and sql trainingvba close applicationwhere is the developer tab in excel 2013vba defineexample of vlookup formulams excel dashboard templatesh look upvba open pdf fileconcatenate excel examplevba textbox propertiesexcel macro delete blank rowsexcell lookupexcel 2003 pivot tablesvba connectionexcel vba end xlupinsert alternate blank rows in excelexamples of ddlmicrosoft excel template downloadsdata control language in sql with examplehow to sort data in excel 2007recordset vba excelexcel graphs examplesaccess vba updatedml definitionlearn vba codingsendmail syntaxusing sql in vbahow to do a pivot table in excel 2013autofiltermode vbaexcel identify duplicate rowsvba remove passwordvlookup example xlshow do you delete duplicates in excelenable developer tab in excel 2010selection vba excelxlworkbook saveasexcel advanced filter exampleexcel protected sheet passwordexcel vba listbox additemexcel chart tutorialenable macros excel 2013excel draw chartpopulate combobox vbaexcel unshare workbookexcel developer menuinsert row excel shortcutpivot chart excel 2013it interview questions and answers for freshers pdfctrl shift d excelexcel macro gotoexcel vba pivot tableexcel vba scriptpower pivot tutorialsms excel dashboard templatesexcel vba columnproject charter template excelfunction vba returncopy and paste in vbawhat is ascending order in excel