EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up

Lookup & Reference Functions in Excel

Home Excel Excel Resources Lookup & Reference Functions in Excel

Lookup & Reference Functions in Excel Courses
  • Online EXCEL COURSE
  • Online EXCEL ADVANCED Training

What is Lookup & Reference Functions in Excel

Lookup & Reference Functions are the often used formulas in excel along with logical functions. Every excel professional must know formulas these are. In this category of functions, you will learn formulas like VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE and LOOKUP functions.

Reference functions like COLUMN, INDIRECT, REPLACE, TRANSPOCE, HYPERLINK, and OFFSET are also covered in this blog. On top these built-in functions we can also learn practical examples like how to match data in excel and mixed reference in excel

Lookup & Reference Functions in Excel Resources

LOOKUP in Excel

TRANSPOSE in Excel

CHOOSE Function in Excel

COLUMN Function in Excel

INDIRECT Function in Excel

HLOOKUP in Excel

MATCH in Excel

VLOOKUP in Excel

OFFSET Function in Excel

Excel VALUE Function

Excel GETPIVOTDATA Function

REPLACE Function in Excel

Excel COLUMNS Function

Address Excel Function

HYPERLINK in Excel

Excel ROW Function

IFERROR with VLOOKUP in Excel

Fixing VLOOKUP Errors

Excel VLOOKUP From Another Sheet

VLOOKUP with Sum

Excel Alternatives to VLOOKUP

HLOOKUP Examples

Excel INDEX Function

CHOOSE Formula in Excel

Excel Lookup Function

Excel OFFSET Formula

Excel COLUMN to Number

IF VLOOKUP Formula in Excel

Mixed Reference in Excel

VLOOKUP Table Array

How to Match Data in Excel

VLOOKUP For Text

ROWS Function in Excel

Compare Two Columns in Excel using VLOOKUP

VLOOKUP True

VLOOKUP with Different Sheets

VLOOKUP Function in EXCEL

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Company
  • About us
  • Alumni Speak
  • Contact Us
  • Log in
  • Sign up
Work with us
  • Careers
  • Become an Instructor
EDUCBA for Enterprise
  • Enterprise Solutions
  • Explore Programs
  • Free Courses
  • Free Tutorials
  • EDUCBA at Coursera
  • EDUCBA at Udemy
Resources
  • Blog
  • Self-Paced Training
  • ExamTurf
  • Verifiable Certificate
  • Popular Skills Catalogue
  • Exam Prep Catalogue
Popular Categories
  • Lifetime Membership
  • All in One Bundles
  • Featured Skills
  • New & Trending
  • Fresh Entries
  • Finance
  • Data Science
  • Programming and Dev
  • Excel
  • Marketing
  • HR
  • PDP
  • VFX and Design
  • Project Management
  • Exam Prep
  • Learning Paths @ $49
  • All Courses
  • Terms & Conditions
  • Disclaimer
  • Privacy Policy & Cookie Policy
  • Shipping Policy

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Web Development & many more.

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Forgot Password?

EDUCBA

डाउनलोड VLOOKUP For Text Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW