Looking to pull data from one worksheet into another in Excel? Whether you're managing inventory, building dashboards, or analyzing reports, learning how to look up data between sheets will save time and reduce errors.

In this post, you'll discover 7 simple and effective methods for doing just that. Be sure to watch the full tutorial video for a step-by-step walkthrough and download the free Excel sample file to follow along.

---

✅ 1. VLOOKUP – The Classic Go-To

The VLOOKUP function lets you search for a value in the first column of a table and return a related value from another column in the same row.

For example, if you have a product ID in cell A2 and a product list on another sheet named "Product Details", you can return the product name by writing a formula that searches column A and pulls the result from column B.

Use this when you’re working with well-structured data and only need to look rightward from your lookup column.

---

✅ 2. INDEX + MATCH – Flexible and Powerful

INDEX and MATCH work together to create more flexible lookups than VLOOKUP allows. MATCH finds the row number where a value appears, and INDEX uses that number to return the value from any column you choose.

This method is especially useful when your lookup column isn’t the first one in the range, or when you want to pull values to the left of the match.

Use INDEX and MATCH when your data layout isn’t compatible with VLOOKUP, or you want a more dynamic approach.

---

✅ 3. XLOOKUP – The Modern Replacement

XLOOKUP is a newer, more powerful function available in Excel 365 and Excel 2021. It replaces both VLOOKUP and HLOOKUP by allowing lookups in any direction and includes built-in error handling.

With XLOOKUP, you simply specify the value to search for, the range to search in, and the range to return the result from. It’s cleaner, easier to read, and more flexible than its predecessors.

Use XLOOKUP when you want modern, readable formulas that work reliably in any direction.

---

✅ 4. Named Ranges – Cleaner, Reusable Formulas

Named ranges let you assign a human-friendly name to a group of cells, like "ProductTable", instead of referencing cell ranges like A2:D11. Once defined, you can use this name in your lookup formulas.

For example, instead of writing a formula that refers to 'Product Details'!A:D, you could refer to ProductTable and still perform your lookup the same way.

Use named ranges when you want cleaner formulas and plan to reference the same table frequently across your workbook.

---

✅ 5. INDIRECT – Dynamic Sheet Referencing

INDIRECT allows you to construct a cell reference or even a sheet name from text. This is useful when you want to refer to different sheets dynamically based on input in another cell.

For example, if cell A1 contains the text “Product Details”, you can use INDIRECT to reference a cell like B5 on that sheet. You can also combine INDIRECT with MATCH to build a flexible lookup that works even when the sheet changes.

Use INDIRECT when building dashboards or templates that pull data from various sheets depending on user input.

---

✅ 6. Cell Reference – Simple and Manual

If you only need to reference one or two values, you don’t need a formula at all. Just type an equals sign, click over to the other sheet, and click the desired cell. Excel will automatically create the reference for you.

This creates a direct link to a cell on another sheet, such as 'Product Details'!B4, which will update automatically if the value in that cell changes.

Use this for quick, one-off references where you don’t need a full lookup formula.

---

✅ 7. Manual Linking – Click and Done

Manual linking is the easiest method of all. Simply type an equals sign in a cell, navigate to the other sheet, click the cell you want to link to, and hit Enter.

Excel builds the reference automatically. While this doesn’t allow for searching or dynamic logic, it’s perfect for small tasks and quick builds.

Use manual linking when you need fast, accurate references without creating complex formulas.

---

📹 Watch the Full Tutorial

Want to see all 7 methods in action?

🎥 Watch the full video tutorial here
Follow along visually to understand exactly how each technique works and when to use it.

---

📥 Download the Excel File

Ready to try it yourself?

💾 Download the sample Excel workbook used in the tutorial.
This file includes demo tables, pre-set formulas, and blank cells where you can test each method on your own.

---

💬 Final Thoughts

Each of these methods offers a unique way to look up data across sheets, from fast manual links to fully dynamic solutions. Knowing when and how to use each one will level up your Excel skills, whether you're a beginner or an advanced user.

Let us know in the comments: Which lookup method do you use most, and why?