EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Formula and Functions VLOOKUP Names
 

VLOOKUP Names

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated May 6, 2023

VLookup Names

 

 

VLOOKUP Names

Vlookup is the most common function that is used in MS Excel activities. We all have used Vlookup to look up the values from the source table to the column or cell we want. But we all have faced the problem when we need to select the range of the table. And sometimes, we end up selecting the incorrect table range or column range in the lookup function. To avoid this, we have the provision of naming the range so that whenever we look up the value from that table or range, we can use the name given to that range. We named this article Vlookup Names and will show you how this works in the example below.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Use VLOOKUP Names?

To create a setup for Vlookup names, we need first to name the table so that only selecting or typing the name of that table will help us select the range. For this, we have some sample data below.

You can download this VLOOKUP Names Excel Template here – VLOOKUP Names Excel Template

vlookup names 1-1

We have two sections, Name and Age, respectively. If we place the cursor on any cell, we will only get the cell position or vertex in the Name box. Let’s place a cursor at cell B1 first.

vlookup names 1-2

Now to name cell B1, let’s go to the name box and write the name we want to give to cell B1. Here we have chosen a Name.

vlookup names 1-3

After that, if we again place the cursor at cell B1, we can see the given name.

Examples of VLOOKUP Names

Lets us discuss the examples of Vlookup Names.

Example #1

In this example, we will see how to name the table used in the Vlookup function. This table has Owner, Quantity Sold, and Product Class columns. And besides that, we have a section where we will look up the value from the first table. For this, we have sales data as shown below.

vlookup names 2-1

Let’s look up the value for the owner name JOHN in cell F2 and get the quantity sold from the first table using Vlookup, as shown below.

Quanity sold

We will then get the value of the quantity sold by John as 4159, as per the value from the first table.

Quanity sold 1

Similarly, as shown below, we will look up the value for Product Class for the same owner John.

product class

Now, once we enter, we can see the value from the first table to cell G2, as shown below.

product class 1

Now to name the range for Vlookup, first select the data from cells A2 to C6. And after that, we can name the table range in any name in the Name Box, as highlighted below.

product class 2

Let’s change the name to Sales_Info, as shown below.

select cell

Again we will apply the Vlookup in the second table as we did earlier. But this time, we will choose the saved table name as the lookup range. So, go to cell F2 and apply lookup, considering the owner as John again.
When we select the range, we will see it will get converted into the name saved name “Sales_Info”, as we can see below.

vlookup names 2-2

Once we enter, we will get the looked-up value from the first table to cell F2 for owner John.

Quanity sold 2

Do the same thing to get product class as well in cell G2.

vlookup names 2-3

Once we enter, we will see the same value as of product class in cell G2, as shown below.

product class 3

We will change the owner name here to test whether we get the correct value using Vlookup names. Let’s use the owner’s name as Sam at cell E2 and see what we get.

After putting Sam in cell E2, the value of Sam’s quantity sold and product class changed to 8486 and 210, respectively.

Quanity sold 3

Example #2

Once we change the name of selected ranges, we can find all the named ranges of the workbook using the path below.

Formula menu -> Name Manager

name manager

Clicking on the Name Manager Option from the Formula tab, we will get the box with a list of names that we have changed or given to any range.

name manager 1

If we click the edit button, we can see the Named ranges upon selecting any listed named values.

edit name

Pros of Vlookup Names

  • Vlookup names are easy to apply.
  • Vlookup names save a lot of time in selecting the range.
  • With the help of this, we can avoid any errors while selecting the ranges.

Things to Remember

  • It is recommended to use Vlookup Names only when we need to apply Vlookup multiple times or select a huge set of lookup ranges.
  • When naming the selected range, do not use spaces. Because spaces are not allowed while naming the range. Instead of space, use underscore (“_”)
  • Vlookup names fix the range so the user does not get any error while executing the Vlookup function for any range.
  • Do not consider the header while naming the selected range.
  • We can edit or change the Vlookup names using the methods shown in example-2.

Recommended Articles

This has been a guide to VLOOKUP Names. Here we discuss How to Use VLOOKUP names, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. VLOOKUP Table Array
  2. VLOOKUP Examples in Excel
  3. VLOOKUP For Text
  4. IF VLOOKUP Formula in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download VLOOKUP Names Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download VLOOKUP Names Excel Template

EDUCBA

डाउनलोड VLOOKUP Names Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW