FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

VLOOKUP False

Updated on January 2, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Why do we need FALSE in VLOOKUP?

In VLOOKUP, there is only one optional argument:[range_lookup].Using this r argument, we can provide two parameters, i.e., TRUE or FALSE.

VLOOKUP optional Argument
VLOOKUP True-False

As beginners, we may not have realized this because, at the learning stage, we are in a hurry, so this goes unnoticed.

Based on the kind of range lookup we give is important. As we have learned above, we can provide TRUE or FALSE. So, let us understand what these two arguments do.

TRUE or 1: If we provide TRUE, it will look for an approximate match.

FALSE or 0: If we provide FALSE, it will look for an exact match.

Since [Range Lookup] is an optional argument, it will take TRUE as the default parameter.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Video Explanation of VLOOKUP Excel Function

 

Now, look at the below data tables in excelData Tables In ExcelA data table in excel is a type of what-if analysis tool that allows you to compare variables and see how they impact the result and overall data. It can be found under the data tab in the what-if analysis section.read more.

Vlookup false Table

Table 1 shows the “Company Name” and its “Revenue details.” However, in Table 2, we have only “Company Name,” so we need to find the “Revenue” details from Table 1 based on the “Company Name” available in Table 2.

Follow the steps to use FALSE in Excel VLOOKUP.

  1. Open the VLOOKUP function in the F3 cell.

    Vlookup false step 1

  2. Choose the Lookup Value as an E3 cell.


    Vlookup false step 2

  3. Next, choose the VLOOKUP table array as the Table 1 range.


    Vlookup false step 3

  4. Column Index Number as 2.

    Vlookup false step 4

  5. The last argument is [Range Lookup]. Mention it as TRUE or 1 in the first attempt.


    Vlookup false step 5

  6. For the naked eye looks like we have got revenue details for all the companies. But this is not the matching data because of the cell E3.


    Vlookup false step 6
    In this cell, we have the word “Florida Milk,” but the actual company name in Table 1 is the “Florida Milk Federation.” Even though these values differ, we still got the revenue details as $120,161. It is the revenue detail of “Florida Incorporation.”

  7. Similarly, look at the F8 cell result.


    Vlookup false step 7
    In this case, the company name is “Florida Inc,” but the actual company name is “Florida Incorporation,” so these two values are not exact. Still, because we have used the match type as TRUE, i.e., approximate match, it has returned the approximate match result.

  8. However, look at the cell F7 for the company “ABC Company.”


    Vlookup false step 8
    In this case, the lookup value is “ABC Company,” but in Table 1, we have “ABC Company Ltd” but still got the correct result. So using TRUE as the criteria for the [Range Lookup], we cannot exactly know how it will end up. So, we need to use FALSE as the [Range Lookup] matching criteria.

  9. For the same formula, change the [Range Lookup] criteria from TRUE to FALSE (0) and see the result.


    Vlookup false step 9
    The same formula. We have only changed the [range_lookup] criteria from TRUE to FALSE and looked at the results. We have the error values for all those cells that do not have exact lookup values, so whichever cells have the exact lookup value in Table 1 has the perfect results.

So 99.999% of the time, we need the exact matching results, so FALSE is the criteria we need to use to get exact matching results.

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

Things to Remember

  • The need for using TRUE may not arise, so always stick to FALSE as the criteria for [Range Lookup]
  • The [Range Lookup] is an optional argument. If you ignore it, it will take TRUE as the default matching criteria.
  • Instead of TRUE, we can give 1 as the criteria, and instead of FALSE, we can provide 0 as the criteria.

This article has been a guide to VLOOKUP False. Here, we discuss the importance of the FALSE statement in the VLOOKUP function [Range Lookup], along with practical examples and a downloadable Excel template. You may learn more about Excel from the following articles: –