Syntax or pattern
Build lookups that return values from another tab in the workbook.
=XLOOKUP(A2, Products!A:A, Products!B:B, "Not found")5 practical examples
Use Lookup from another sheet to find a product price
Return the matching product price from a lookup table.
=XLOOKUP(A2, Products!A:A, Products!B:B, "Not found")Adjust the ranges, criteria and sheet names to match your workbook.
Use Lookup from another sheet for employee details
Find a department, manager, or role from an employee ID.
=XLOOKUP(A2, Products!A:A, Products!B:B, "Not found")Adjust the ranges, criteria and sheet names to match your workbook.
Use Lookup from another sheet with a status table
Convert status codes into readable labels.
=XLOOKUP(A2, Products!A:A, Products!B:B, "Not found")Adjust the ranges, criteria and sheet names to match your workbook.
Use Lookup from another sheet to pull a category
Return a category for reporting and summaries.
=XLOOKUP(A2, Products!A:A, Products!B:B, "Not found")Adjust the ranges, criteria and sheet names to match your workbook.
Use Lookup from another sheet with imported data
Look up a value from an imported or shared tab.
=XLOOKUP(A2, Products!A:A, Products!B:B, "Not found")Adjust the ranges, criteria and sheet names to match your workbook.
Common mistakes to avoid
- Using lookup ranges and return ranges with different row counts.
- Leaving extra spaces in lookup values.
- Forgetting a fallback value when a lookup can be missing.
FAQ
What is this Google Sheets page for?
This page gives copy-ready examples for lookup from another sheet examples so you can understand the pattern and adapt it to real spreadsheet work.
Can I copy these formulas directly?
Yes. Use the copy buttons, then adjust sheet names, ranges, criteria and column references for your own file.
Why does my formula return an error?
The most common causes are mismatched ranges, missing quotes around text criteria, blank source data, or references that do not match your sheet layout.