Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • 150 Keyboard Shortcuts
  • Contact

Excel Lookup and Reference Functions

  • Home
  •   »  
  • Excel Functions
  •   »  
  • Excel Lookup and Reference Functions
Excel Functions Excel Lookup and Reference Functions
XLOOKUP – Excel Function

XLOOKUP – Excel Function

What it does: The XLOOKUP() Function allows you to look up and return values in corresponding columns or rows (!!). I have an

Excel Functions Excel Lookup and Reference Functions
INDEX – Excel Function

INDEX – Excel Function

What it does: THE INDEX() Function returns a value based on the array of values you select and the row and column within that

Excel Functions Excel Lookup and Reference Functions
HYPERLINK – Excel Function

HYPERLINK – Excel Function

What it does: The Hyperlink() function links the cell to a local location (another point in the spreadsheet, another tab,

Excel Functions Excel Lookup and Reference Functions
MATCH – Excel Function

MATCH – Excel Function

What it Does – Locate the position (often the row number) of an item in an array. Arguments: MATCH(lookup_value,

  • Articles
  • Excel Training Videos
  • Books on Excel & Data
  • 150 Keyboard Shortcuts in Excel (Windows)
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com