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