Lookup Like a Pro

Why lookups matter in data analysis

In real-world data analysis, information is rarely stored in one neat table. Product details may live in one sheet, sales transactions in another, and customer data in a third. Manually searching through thousands of rows to connect these pieces is slow, error-prone, and unsustainable.

This is where lookup functions come in.

Lookup formulas allow us to:

• Automatically fetch related data

• Connect tables using unique identifiers

• Eliminate manual searching

• Build scalable, analysis-ready spreadsheets

Mastering lookups is a major step toward professional data analysis in Google Sheets.

What is a VLOOKUP?

VLOOKUP() is a vertical search tool. It looks for a value in the first column of the data and grabs related information from the same row in another column when it finds it. This tool is great for adding product details to a sales report, or finding customer information from a main list.

How to use VLOOKUP in Google Sheets

It takes four parameters, as mentioned below.

• search_key: The value we are looking for.

• range: The block of data we want to search in.

• index: The column number within our range that contains the data we want to retrieve.

• is_sorted (Optional): Determines whether the function looks for an exact or approximate match. The value of is_sorted can be either TRUE or FALSE.

  • FALSE: Exact match. The function returns a result only if it finds the exact search value.

  • TRUE (Default): Approximate match. The function returns the largest value less than or equal to the search key. For example, if we search for 10:

    • In the list 9, 11, it returns 9.

    • In the list 9, 10, 11, it returns 10.

Example: Using VLOOKUP to calculate revenue

Suppose we have two separate sheets:

• A Product catalog sheet that contains detailed information about each product, including the ProductID, Product Name, and Unit Price.

• A Sales data sheet that lists every sale by Order ID, ProductID, and Quantity Sold.

Our goal is to figure out the total revenue for each sale. We can’t do this with just our sales data because it’s missing the price of each product. This is the work of VLOOKUP. We’ll use the ProductID as our unique identifier to find the Unit Price in the Product catalog sheet, and bring it back to our Sales data sheet.

The following Product catalog sheet acts as our main list, containing the details we need to look up:

VLOOKUP() requires the lookup value (in this case, ProductID ...