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 codeprogram vbasql database for beginnersestimate sheet templatescreating a stock chart in excelexcel expert tutorialexcel insert worksheetms access mcq questions and answersbackground color vbaexcel timeline chart templatevba activate workbookcheckbox in excel 2007activate sheet vbaexcel unsharehow do you insert a column in excelvba check if file existsexcel macro create buttonvba yes no boxnested if statement in excel 2010how to insert a title on excelfind duplicates in excel columnsvba charactervba entire row deleteinsert row vbavba and macros for microsoft excelexcel vba message box yes noexcel hyperlink to websiteexcel vba application ontimesas stands forlook up functions in excelsample excel data for pivot tablesum if in exceladding password to excelhow to do vlookup in excel 2007 step by stepmacro delete blank rowscreating excel dashboardshighlight a column in excelhyperlink in vbacapacity planning spreadsheet excelactivex definitiondelete hidden rows in excelexcel macro repeatvba tutorialsactivate worksheet vbaproject status dashboard template powerpointexcel graphics tutorialhide unused cells in excelexcel worksheet hiddendelete range vbavb automation errorexcel vba backcolorrange cell vbavlookup function on exceldml ddldml databasefind duplicate rows excelexcel vba securityvlookup examplessample excel macro coderemove duplicates in excel 2013formula to find duplicate values in excelclose excel in vbainsertrangeremove blank rows excel 2010vba word macrosexcel vlookup formulamicrosoft excel macro examplesuseful macros excelsql interview questions and answers pdf for freshersexcel chart headerlast cell excelsql or sasinsert a column in excelvba not equal towhat is vlookup formula in excelworksheets vba excelexcel macros tutorial