Google Sheets VLOOKUP From Another Sheet

VLOOKUP from another sheet in Google Sheets pulls a matching value from a different tab. It is useful when one tab is the working table and another tab stores reference data such as clients, products, owners, rates, categories, or deal stages.

Use this pattern when you want one source of truth for lookup data instead of copying the same values into every row manually.

The syntax

• search_key - the value to find
• range - the lookup table, including the matching column and return columns
• index - which column in the range should be returned
• [is_sorted] - use FALSE for exact matches in most operating sheets

Basic cross-sheet example

Say your working tab has client IDs in A2:A, and a tab named Clients has ID, client name, owner, and hourly rate in columns A through D.

To return the client owner:

To return the hourly rate:

That works well in an invoice template or CRM lead tracker when client details should be maintained in one reference tab.

Sheet names with spaces

If the sheet name contains spaces, wrap it in single quotes:

Without the quotes around the sheet name, Google Sheets will not read the tab reference correctly.

Avoid exact-match surprises

Use FALSE for exact matches unless the lookup table is intentionally sorted for approximate matching.

Most CRM, sales, invoice, and project workflows need exact matches. Approximate matching can return a value that looks valid but belongs to the wrong row.

Common VLOOKUP problems

The Griddy way

Cross-sheet lookups are fragile when IDs are inconsistent or the return column keeps moving.

"Pull the owner and billing rate from the Clients tab into this invoice log, use exact matches, and flag any client IDs that do not match"

Griddy can build the lookup formulas, check the reference tab, and identify missing or mismatched keys before the sheet gets used for billing or review.