EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

IF VLOOKUP Formula in Excel

By Madhuri ThakurMadhuri Thakur

Secondary Sidebar
Excel Functions
  • Lookup Reference Functions in Excel
    • VLOOKUP Function in EXCEL
    • VLOOKUP True
    • VLOOKUP Error
    • How to Match Data in Excel
    • Excel Match Function
    • Excel Lookup Function
    • ROWS Function in Excel
    • Excel INDEX Function
    • VLOOKUP Table Array
    • Excel OFFSET Formula
    • VLOOKUP For Text
    • IF VLOOKUP Formula in Excel
    • Mixed Reference in Excel
    • CHOOSE Formula in Excel
    • Excel COLUMN to Number
    • Excel Alternatives to VLOOKUP
    • HLOOKUP Examples
    • Excel VLOOKUP From Another Sheet
    • VLOOKUP with Sum
    • Fixing VLOOKUP Errors
    • Excel ROW Function
    • HYPERLINK in Excel
    • Address Excel Function
    • Excel COLUMNS Function
    • Excel REPLACE Function
    • OFFSET Excel Function
    • Excel GETPIVOTDATA Function
    • MATCH Function in Excel
    • VLOOKUP Function in Excel
    • HLOOKUP Function in Excel
    • LOOKUP in Excel
    • CHOOSE Function in Excel
    • TRANSPOSE in Excel
    • COLUMN Function in Excel
    • INDIRECT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL COURSE
  • Online EXCEL ADVANCED Training
Home Excel Excel Resources Lookup & Reference Functions in Excel IF VLOOKUP Formula in Excel

if vlookup formula in excel

IF VLOOKUP Formula in Excel (Table of Contents)

  • Introduction to VLOOKUP Formula in Excel
  • How to Use IF VLOOKUP Formula in Excel?

Introduction to VLOOKUP Formula in Excel

Using Vlookup along with IF Function in Excel is used to get conditional results on the basis of compared values. When we use the IF function with Vlookup, then the IF statement compares the result obtained from the vlookup statement with the selected value. An easy way to apply Vlookup with IF is to apply the Vlookup function with the complete range and then use this syntax with IF Statement. We can have any statement or output if the value obtained from vlookup comes TRUE or FALSE. And always quote the final statement, which we want in inverted commas.

Start Your Free Excel Course

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

Syntax

IF VLOOKUP Example 3-4

Arguments

  • Lookup value – This refers to a cell value or a text that you are looking for
  • Table_ array – Defines the range of cells or source where you want to look for the value.
  • Col_index_number – Number of the column from which you want to return the value.
  • Range_lookup – True or false to get the exact match or similar data.

How to Use IF VLOOKUP Formula in Excel?

IF VLOOKUP Formula in Excel is very simple and easy. Let’s understand how to use the IF VLOOKUP Formula in Excel with some examples.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,275 ratings)
You can download this IF VLOOKUP Formula Excel Template here – IF VLOOKUP Formula Excel Template

Example #1 – Using the IF Function with Vlookup

Below is an example of using the “IF” function with Vlookup. The lookup value is compared with an integer value. Where the list of items and their quantity is given, from the given list need to find whether the specified product is in stock or not.

IF VLOOKUP in Excel example 1

Please select the Item and paste it in a cell for which we want to check whether the item is in stock or not.

IF VLOOKUP in Excel example 1-1

Select the cell F2 where you want the get the final result and apply the formula IF VLOOKUP.

IF VLOOKUP in Excel example 1-2

The function Vlookup is applied as VLOOKUP (E2, $B$2: $C$15,2, FALSE) to find the quantity of the item name given in F2.

And using “IF”, this Vlookup result will be compared with “0”.

  • If the quantity is not equal to zero, it will return “Yes”; that is, the stock is in hand. Else it will return “No”, which means the stock is not in hand.

Here we have checked the item “tobacco_barn” is in stock or not. Since the Quantity is not zero, it returned the value “yes”.

Example #2 – Compare the Vlookup Value with Another Cell Value

Let’s look at an example to compare the Vlookup value with another cell value.

IF VLOOKUP Example 2-1

The above given are the different products and their amount of sales that have done for a period. We need to find if there any maximum sales for a specified item.

Select the cell C2 and apply the formula, By using the MAX Formula.

IF VLOOKUP Example 2-2

The result value will be pasted to cell E2. And is the highest amount of sales done within the given data.

To check the product given in D2, is there any maximum sales that occurred or not.

Select cell E2 and apply the formula.

IF VLOOKUP Example 2-3

The formula applied with a logical operation by referring to a cell value in E2. For the product given in E2 is the maximum sales happened. So the result of the applied IF function is “Yes”.

  • IF function will perform a logical operation with the Vlookup value and return a Boolean value.
  • According to the result, the true section or false section will be returned as the final output.
  • Instead of true or false, you can mention any text in both sections.

Example #3 – IF Vlookup Formula to perform Multiple Calculations

Apart from displaying the text messages given, this formula combination can be used to perform different calculations based on given criteria.

  • IF Vlookup is used to perform different calculations according to the Vlookup condition.
  • More than one Vlookup function can be associated with the IF function.
  • Instead of using texts, the Vlookup function is performed in the true and false section.

 IF VLOOKUP Example 3-1

It gives the products and the amount of sales done by different sellers. Here we need to find the commission for the seller specified in cell D2 according to the sales they have completed.

IF VLOOKUP Example 3-2

If the sales amount is greater than $50, then 20% commission will be provided else 10%. So these two conditions are specified in the given formula.
IF VLOOKUP Example 3-3

The IF function is performed on this result by applying a logical operation “>=50”.

If this condition satisfies, then the true section of the IF function will be performed: VLOOKUP (D2, A2: C15,3) *20%; it returns the 20% of the sales done for the specified person.

When the IF condition does not satisfy VLOOKUP (D2, A2: C15,3) *10%, this formula will be executed. And it will return 10% of the sales amount.

Here the first condition satisfies and returns 20% of the sales value of the specified person.

So the 20% of the sales amount done by salesperson Alwin will be returned as the final output that is 10.

Things to Remember About IF VLOOKUP Formula in Excel

  • Should be careful about selecting the range where you want to apply the IF(Vlookup(..)) function.
  • To avoid mismatches while copying the formula, use the $ symbol along with the range value.
  • IF with Vlookup function is used when you want to take any decision based on the result.
  • Along with the IF function, any text message can be given in the true and false sections.

Recommended Articles

This is a guide to IF VLOOKUP Formula in Excel. Here we discuss How to use the IF VLOOKUP Formula in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. VLOOKUP Examples in Excel
  2. VLOOKUP Tutorial in Excel
  3. IFERROR with VLOOKUP in Excel
  4. Excel Alternatives to VLOOKUP
Popular Course in this category
Excel Training (23 Courses, 9+ Projects)
  23 Online Courses |  9 Hands-on Projects |  110+ Hours |  Verifiable Certificate of Completion
4.9
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
4 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

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

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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download IF VLOOKUP Formula Excel Template

EDUCBA

Download IF VLOOKUP Formula Excel Template

EDUCBA

डाउनलोड IF VLOOKUP Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Special Offer - Excel Training (18 Courses, 9+ Projects) Learn More