Site icon Best Excel Tutorial

How to Vlookup other Tab in Excel?

Excel’s VLOOKUP is a powerful feature. It finds and retrieves data from one tab to another. This guide breaks down the process into easy steps. It makes data management efficient.

Preparing Your Excel Workbook

Start with organization. Ensure all relevant tabs are in one workbook. This step is key.

Understanding VLOOKUP’s Parameters

VLOOKUP needs four pieces of information:

Implementing the VLOOKUP Formula

Go to the target cell. Type in the VLOOKUP formula. Follow this structure:

=VLOOKUP(value, ‘Tab Name’!A:B, 2, FALSE)

This formula looks for a value. It searches in ‘Tab Name’ from columns A to B. It returns data from column 2. It seeks an exact match.

A Practical Example: Sales Data Analysis

Consider two tabs: “Products” and “Sales”. “Products” lists item names and IDs. “Sales” tracks sales figures by ID.

You want to match product IDs to sales figures. You aim to display this data in “Products”.


  1. In “Products”, next to the product ID, enter your formula. Use the product ID as your search value.
  2. Set the formula to look in the “Sales” tab. Specify your data range. For sales figures, choose the correct column.
  3. Use FALSE for an exact match.
Exit mobile version