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 Lookup & Reference Functions in Excel VLOOKUP True
 

VLOOKUP True

Ashwani Jaiswal
Article byAshwani Jaiswal
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated May 8, 2023

VLOOKUP True

 

 

VLOOKUP with True

When we apply the Vlookup function, it is obvious that we always look for the exact match. When we get the #N/A, we also assume that the value we are looking for is unavailable in the lookup table. But we have yet to try using Vlookup with a TRUE value match. We can use two criteria in Vlookup functions, which are TRUE and FALSE. FALSE gives us the exact match, whereas TRUE gives us the approximate match for the value if not in the lookup range. Vlookup True is used when we don’t get an exact match, but with the help of TRUE, we can get an approximate match or near value to the value which we are looking for.

Watch our Demo Courses and Videos

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

How to Use Vlookup True?

To understand the use of Vlookup True, first, we need to understand the syntax of Vlookup. Below we have the syntax of Vlookup;

vlookup names 1-1

Where,

  • Lookup_Value = Cell value whose value we need to find.
  • Table_Array = Range or table from where we need to find the value of lookup_value.
  • Col_Index_Num = sequence number of the column from which we want to get the value.
  • Range_Lookup = 0 (or FALSE) for the exact match and 1 (or TRUE) for the approximate match.

We will be seeing the use of TRUE and FALSE range_lookup value and will see how Vlookup True works in the below examples.

Examples of VLOOKUP True

Lets us discuss the examples of VLOOKUP names.

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

Example #1

In this example, we will see the simple way to apply Vlookup True. For this, we have a list of alphabets, as shown below. As we can see, the alphabets are in proper sequence. And in separate cells, we will be looking up the values from the list and see the output.

vlookup names 1-2

In cell C2, we will put any of the alphabets we want to look up from Column A. Let’s consider it D.

vlookup names 1-3

In cell D2, insert the vlookup function and select the lookup value and range as needed.

vlookup names 1-4

To get the exact match, we can select FALSE range lookup or 0 for the exact match as shown below.

vlookup names 1-5

Once we enter, we can see that cell D2 will have the exact match value from the selected range.

vlookup names 1-6

Now, if we delete the Lookup Cell value D from the list available in column A, then Vlookup will not be able to look up anything and will return #N/A.

vlookup names 1-7

If we change the range lookup value of Vlookup syntax from FALSE to TRUE (or 1), we will get an approximate match for the lookup value D in cell D2 as shown below.

vlookup names 1-8

Once we exit the syntax, we will get the value nearer to the lookup cell value D in cell D2.

mapped value

As we can see, the obtained value at cell D2 is C. This is because Vlookup TRUE gives the near about value if the exact match is unavailable. Here for the D, it returned the approximate match as C because C is the only near value before D.

Example #2

In this example, we will see how Vlookup True works with a larger data set. Below is a table where the names of the different persons, ages, and physique types are mentioned from Columns A to C. And there is another small table in column E: F where we will map the value from table 1.

Example 2-1

As we can see, we have age and physique types for each person. Now, let’s find out the physique type of any age, say 26. Insert the vlookup at cell F2 as shown below.

Example 2-2

Select the lookup cell E2 and the Lookup range from B2 to C8, as shown below.

Example 2-3

Considering FALSE for range lookup, we will get the exact match.

Example 2-4

Now, if we randomly change the age from 26 to 53 in cell E2 and again apply the lookup using TRUE range lookup criteria and see what we will get? As of now, when we change the cell E2 value from 26 to 53, we got #N/A, as there is no value in column C available for age 53.

Example 2-5

Now we will apply the Vlookup function using TRUE.

Example 2-6

Once we press enter or get exited from the Vlookup syntax, our physique type in cell F2 is GENERAL, as shown below.

Example 2-7

The reason for getting General in cell F2 is the TRUE range lookup in vlookup syntax. As we did not have the age as 53, so Vlookup True returned us the value as General because, before 53, we got general physique in cell B4.

If we again change the value, let’s say 31. Then we will get a value closer to 31 per the table. Here we have 30 in cell B2.

Example 2-8

Pros of VLOOKUP True

  • It helps us get the approximate match if we do not have the exact value for the lookup cell.
  • It is as simple as Vlookup False.
  • Using this function is far better than using different IF condition functions.

Things to Remember

  • It gives an approximate match.
  • We can also use 1 in place of TRUE in the VLOOKUP syntax.
  • For the numerical value, It looks up the value less than the value available in the lookup cell.
  • Vlookup False gives the exact match, and if the match value is not available, then we will be getting #N/A
  • #N/A means the lookup cell’s value is not found in the entire lookup range.
  • The lookup range could be a table or column, but the value we will get from the column only.

Recommended Articles

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

  1. VLOOKUP Names
  2. VLOOKUP Table Array
  3. VLOOKUP For Text
  4. VLOOKUP with Sum

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 True Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download VLOOKUP True Excel Template

EDUCBA

डाउनलोड VLOOKUP True Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW