How to find Vlookup and Return the Matching Values from Multiple Worksheets?
Tags: kutoolsexceltutorial, vlookupandreturnthem, kutools
Published: 2021-06-25 03:04:01

---
title: How to find Vlookup and Return the Matching Values from Multiple Worksheets?
published: true
date: 2021-06-18 10:09:19 UTC
tags: KutoolsExcelTutorial,VlookupandReturntheM,Kutools
canonical_url: https://geekexcel.com/how-to-find-vlookup-and-return-the-matching-values-from-multiple-worksheets/
---

## Vlookup and Return the Matching Values from Multiple Worksheets:

In this article, we are going to see how to find **Vlookup and Return the Matching Values**  **from Multiple Worksheets**. This can be easy to solve if you have Kutools for Excel. Because it has a specific function of  **LOOKUP Across Multiple Sheets**. We can do this with several clicks only.

## Vlookup and Return the Matching Values from Multiple Worksheets:

First, you need to enter the data in multiple worksheets. Here are the following worksheets with data.

![Sheet 1](https://geekexcel.com/wp-content/uploads/2020/07/cv38.png)<figcaption id="caption-attachment-10510">Sheet 1</figcaption>

![Sheet 2](https://geekexcel.com/wp-content/uploads/2020/07/cv39.png)<figcaption id="caption-attachment-10511">Sheet 2</figcaption>

![Sheet 3](https://geekexcel.com/wp-content/uploads/2020/07/cv40.png)<figcaption id="caption-attachment-10512">sheet 3</figcaption>

- You can apply the **LOOKUP Across Multiple Sheets** function of Kutools to do this.
- On the **Kutools** tab, Select the **Super LOOKUP** option, choose the **LOOKUP Across Multiple Sheets ** option from the drop-down list.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv28.png)

- It will open the **LOOKUP Across Multiple Sheets** dialog box.
- In that dialog box, you need to fill the **Lookup Values and Output Range boxes** under the Lookup value and output range section.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv29.png)

- Then, you have to **click** the + button and it will open the Data Range dialog box.
- **Click** the **Sheet tab** to go to that worksheet which contains the data you need, and **select the data range**.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv30.png)

- Click the **ok** button. It will open the **Add Date Range** dialog box.
- You have to specify the **key column** and **return column**.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv31.png)

- Press the **Ok** button. It will go to the main dialog box.
- Now, you can see the data range of the first sheet has been added into the **data range** list box.
- Repeat the above five steps to add data ranges of other (sheet 2 and sheet 3) worksheets and it will be listed below.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv32.png)

- Now, **Click** the **Ok** button. Then the prompt box will open. If you want to save this means click **yes** otherwise click **No** button.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv33.png)

- Here, I will click **Yes** to save this Scenario.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv34.png)

- Then Click **ok** to return all the matching values from multiple sheets.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv35.png)

### Notes:

- If **#N/A error** occurs, you need to check the **Replace #N/A error value with specified value** option and type the text you need.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv36.png)

- **LOOKUP Across Multiple Sheets** dialog box has the following options in it.

1. **Add** – It is used to add the data range from the other worksheet.
2. **Edit** – Used for edit and modify the selected data range.
3. **Delete** – It is used to delete the data range from the data range list box.
4. **Move Up / Move Down** – It will move the added data range up or down.
5. **Save Scenario** – To save the current added data range as a scenario for the next use.
6. **Open Scenario** – It is used to manage the scenarios like delete or open the scenarios.

![](https://geekexcel.com/wp-content/uploads/2020/07/cv37.png)

## Verdict:

In the above article, you can understand **Vlookup and Return the Matching Values from**  **Multiple Worksheets** in Excel using Kutools. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Create a Timeline Or Milestone Chart in Excel 365?](https://geekexcel.com/how-to-create-a-timeline-or-milestone-chart-in-excel-365/)
- [How to Create a Drop-Down List in Excel 365? -Using Kutools](https://geekexcel.com/how-to-create-a-drop-down-list-in-excel-365-using-kutools/)