Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More

© Mandeep Mehta 2021

M. MehtaMicrosoft Excel Functions Quick Referencehttps://doi.org/10.1007/978-1-4842-6613-7_6

6. Lookup & Reference Functions

Mandeep Mehta¹  

(1)

Mumbai, India

 

In this chapter, we will look at some of the most commonly used lookup and reference functions in Excel.

Note

In the search range argument used in this chapter, it is suggested you use absolute references. This will make it easy to copy formulas to other locations without changing the search range.

Let us now look at some of the common lookup and reference functions.

VLOOKUP Function

The VLOOKUP function is used to perform vertical lookups. Here, a value is searched for in the first column of a range, and a value in the same row from a specified column of the search range is ...