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.

Lock the lookup table before filling down so it does not shift by one row each time:

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.

Handle missing IDs without hiding data problems

Use IFNA to replace only the not-found case:

If blank source rows should stay blank:

Do not turn every failure into an empty cell. A visible warning is more useful when a missing client would affect billing.

Clean matching fields safely

For ordinary leading, trailing, or repeated spaces, clean a helper column with:

TRIM preserves a single space between words. Do not globally delete every space: North Carolina and person or company names contain meaningful spaces. Non-breaking or non-printing characters may need a targeted SUBSTITUTE or CLEAN after you identify the character.

Common VLOOKUP problems

Do this with AI

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.

See how to use XLOOKUP in Google Sheets when you need left lookups or an explicit last-to-first search.

Sources

• Google Docs Editors Help: VLOOKUP function and troubleshooting
• Google Docs Editors Help: Improve LOOKUP performance
• Google Docs Editors Help: TRIM function