EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

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 Match Function

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
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, 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

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

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 Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Match Function in Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Special Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) Learn More