Suppose, cells ‘B2:E6’ is the data containing the marks of Students in the 3 subjects shown. Similarly, for the ‘Vlookup’ Function, suppose you have data in a table, and you want to look up a value in any of the columns corresponding to a value in the left column of the table. In the above formula, “logical_test” is the condition on which we are testing, then the value if the condition is True, and then Value if the condition is False. ‘If’ is used when you want to have a condition decide which value is to be populated in a cell. I will briefly explain to you the ‘IF Statement’ & ‘Vlookup’ Function, so that combination becomes easier to explain.
‘Vlookup’ with ‘If’ statement: Returns ‘True/False’ or ‘Yes/No.’
VLOOKUP IN EXCEL HOW TO
Here, we will combine the twin functions of ‘IF Function’ & ‘VLOOKUP.’ We will also see how to deal with #NA errors, which we might sometimes receive while using a combination of ‘IF Statement’ & ‘VLOOKUP.’ While the two are quite important on their own, together, they provide more value. Vlookup is a reference function while if is a conditional statement in excel, these both functions are combined together to find out certain value which meets the criteria and also match the reference value, based on the results of Vlookup function If statements display the result, in other words, we nest Vlookup in If function.