In this article, you will learn how to use VLOOKUP function as an alternative to a number of Nested IF functions in Microsoft Excel.
VLOOKUP function is used to return a value from the data on the basis of common and unique lookup value from the leftmost column.
Note: If we do not have the common value in other data from which we want to pick the data, then the formula will give the #N/A error. As you can see in the above-shown snapshot, the employee code L1089 in not available in 1st data set so formula is displaying an error.
IFfunction is used to check if a condition is met and returns one value as True and another value as False.
Let’s take an example to understand how and where we can use Vlookup function instead of nested IF function.
In Excel, we have serial wise scores, column A contains serial numbers, and column B contains scores. We have a drop list of serial numbers in cell C2. We want if we select any number from the drop down list, cell D2 shows us the scores for that serial number.
First we will try through If function, follow below given steps:-
Now, let’s use VLOOKUP function:-
Follow below given steps:-
Note: - This alternative will work only for lesser data, because in a cell, we are allowed to put the If condition 7 times only.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.