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

merging excel columnsmerge multiple worksheets into onechr function in vbaformula replace excelvba introductionvba code to open a filefor each loop vbaexcel colour indexsql query practice questions answers pdfexcel graph examplesexcel macro beginnermerge multiple worksheets into oneexcel find duplicate valueshow to hide lines in excelpublic variable vbafiledialog filteraccess 2010 msgboxdashboard template excelexcel modules tutorialsumif function on excelvb msgboxpassword protecting an excel spreadsheetexcel vba basicsrecord macro in exceldownloadable gantt chartproject management timeline templatewhat is vba macroshortcut keys to exceladvanced userform excel vbaaverage function excel 2010how to use hlookup in excel 2007 with exampleselect range in vbaadvanced excel tips and techniquesexcel macro checkboxmacro programming excelexcel vba radio buttonhow do i remove blank rows in excelhyperlink function in excelhow to make radio buttons in excelexcel vba create userformexcel insert row macropowerpoint macro tutorialexcel unhide sheetdata entry form in excel 2007enable macros in vbacost estimate excel templateexcel worksheet name from cell valuearrays vba excelhow to call a subroutine in vbainterior vbaexcel copy cell to another sheetmacro to unprotect workbookunprotect workbook excel 2013developer toolbar excelexcel vba combobox rowsourceshow merged cells in exceladvanced excel shortcut keysvba datediffmerge worksheets into oneusing nested if in excelfinancial analyst interview questions and answers pdfhow to unhide column a in excel 2013word vba formmerge multiple excel files into one sheet vbaunhide rows in excel 2013short cut keys for excelunlock excel protected sheetadd the developer tab to the ribbon in wordcompare dates vbaexcel macro programming tutorialsumif function excel 2010password protect excel worksheethow to use count function in excel 2007merging excelvb scripting in excelexcel auto row height