How To Use If And VLOOKUP Together – Excel Formula


How To Use IF and VLOOKUP Together

As discussed in the previous posts, VLOOKUP function has feature to mingle with other excel function or formulas. You are going to learn the way how we can use the IF condition with VLOOKUP Function. IF condition also very powerful formula in the excel and other programming languages.

IF Condition:

IF condition is logical function. For example if you want to test one cell whether there is a value or not, you can use this function and know the result, if condition has two variety of options 1) True Block, 2) False Block and one condition. When condition is true then True Block executes. Similarly condition is false then False block executes. Hence VLOOKUP can be used in this either in True block or in False block depending upon our requirement. We have already given you about the VLOOKUP functionality.

Syntax : =IF(Condition, True_Block, False_Block)

VLOOKUP Function:

Since we have already discussed about VLOOKUP in detailed manner, I am going to provide you simple example on the VLOOKUP function. It provides you the right side value as result based on given left side value. And it works column wise. Means we can give the table array as columns only.

Syntax: VLOOKUP(LOOKUP_Value,Table_Array,Column_Index_Number,Exact_Match (False or 0), Approximate_Match (True or 1))


How to use VLOOKUP and IF Condition in single formula


See Also:

Vlookup function
Vlookup Errors in Excel – Excel Formula












  1. Hi! I know this is somewhat off-topic but I needed to ask.
    Does managing a well-established blog like
    yours take a massive amount work? I am completely new to operating a blog but I
    do write in my diary daily. I’d like to start a blog so I can easily share my experience and views online.
    Please let me know if you have any suggestions or tips for
    brand new aspiring bloggers. Thankyou!

    • Hi, It is very simple to manage this kind of blog. All you need to do is to write the content daily 500 words approximately. One certain day, your blog would succeed. I also still need to write much content.However thanks for your comment in my blog

  2. Everyone loves what you guys are up too. This type of clever work and reporting!
    Keep up the awesome works guys I’ve included you guys to our blogroll.


Please enter your comment!
Please enter your name here