- 1 How To Use IF and VLOOKUP Together
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 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)
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