# 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

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

Nice post to learn vlookup

This is nice blog.

Thank you for the good write up. In fact it was a

amusement account. it Looks advanced to more added agreeable from you!

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.

One of our visitors has introduce your website. It is very awesome to learn excel. Thank you!!!

Very attractive to learn excel

Nice content about vlookup

Your explanation about IF condition is awesome. Expecting more articles from your blog.

Thanks for your explanation on vlookup. You have in depth knowledge in building this vlookup and other excel formulas stuff. Thank you and we keep following your blog.

Hey, you used to write great, but the last several posts have been kinda boring… I miss your tremendous writings. Past several posts are just a bit out of track! come on!

Some genuinely quality posts on this site, saved to favorites.