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

vlookup tutorial in excelfrequently asked interview questions and answers for freshersexcel vba application formulastacked line graph excelcompile data from multiple excel worksheetscreating a check box in excelvb6 calculatorexcel vba selection objectexcel macro samplems excel vlookup exampleshow to create a pivot chartpurpose of vlookuphow to insert a check box in excelexcel vba remove rowhow to combine data from multiple worksheets in excel 2010macro recording excelworkbooks open vbacopy tabs in excelvba userform codeunhide columns in excel 2010sumif excel 2007vba run commandvb color indexhow to consolidate excel sheetsunprotect sheet excelnested if in excel examplems access vba msgboxsql for begginersexcel advanced filter criteria range examplesvba nullexcel multiple if conditiongantt chart template wordproject manager excel templateconditional vlookupembedded chart excelhow to delete duplicates in excel 2010sql sas tutorialexcel logical formulasexcel activeworkbook saveashow to write macro program in exceldynamic range vbaexcel 2010 chart titlevba procedurevb listboxexcel construction estimate templateclose word document vbaexcel vba switchdashboard formats in excelunhide top rows in excelexcel vba concatenate cellsexcel vba change cell color based on valuehide rowsshortcut key for pivot table in excel 2010excel vba new worksheetarrays in excel vbahow to crack excel vba passwordhow to autofit in excelexcel 2007 pivot chartwhat if statements in excel 2010vba worksheet nameexample vba codevba unhide all rowsiferror excel 2010vba hide columncode in vbasubstitute excel formulaexcel pivot tables explainedcustomer service dashboard excelexcel chart basicsvbs messageboxvba sumifsexcel vba sortingmove worksheet to another workbooksql queries excelexcel vba continue fordisplay duplicates in excelclustered cylinder chart excelshortcut formula in excelprompt vbaunprotect sheet excel passwordhow to unlock a password protected excel filevb6 create text fileexcel macro workbooks openswot analysis templates for word