There are many people out there who have learned VLOOKUP but they are getting confused when and where to apply it in Excel. So to get rid of your confusion I will be talking about VLOOKUP Step 1 which is absolute basics and also I will show you how to How to use this Foundation VLOOKUP in Excel
How to use VLOOKUP in Excel?
To use VLOOKUP in Excel. I will be going to explain you through my type of story by which you will understand when and where to apply it in Excel
So here I have 4 students in my story
Now I want to know the answer of Sourav Dada by finding the source of it so you can apply this step by step process which will help you to find your answer
Step 1: Copy the name of Sourav Dada
Step 2: Then press Ctrl + F
Step 3: A pop up will open paste the name on it
Step 4: Click on Find Next
Step 5: Lastly, the cursor will navigate and click on your name in order to know the answer
I think that the name should come automatically which means if I change my name from Sourav Dada to Jignesh Bhai then I should get my answer.
So to quickly find your answer, first let us go through a detailed process to apply VLOOKUP and find your answer in Excel
How to apply the VLOOKUP formula to find an answer in Excel?
To apply VLOOKUP Formula in Excel what I have done is:
Step 1: Firstly I have written this VLOOKUP Formula
Now the first parameter is saying lookup value and not lookup values that mean 1 time only 1 value or 1 cell so what we will do is
Step 2 – Next I have chosen the cell to find an answer so it becomes =VLOOKUP[N1,
Now VLOOKUP tells us that whichever LOOKUP value I have chosen that LOOKUP value must be there in the first part of the column. If you have selected the entire column then you will not find your answer
Step 3 – So I have selected column 1 and column 2 which becomes =VLOOKUP[N1,N6:09,
Now the formula link is becoming like that =VLOOKUP[N1,N6:09, which means LOOKUP value is Sourav Dada and the name should be there in this table. If the name is there in 1 column then we have to find the answer from the 2 columns so what I will write is
Step 4 – I will write the above formula and add the value 2 along with comma which becomes =VLOOKUP[N1,N6:09,2,
Now after writing the above formula now the range LOOKUP is saying True and False in which
TRUE= Appropriate Match
FALSE = Exact Match
Step 5- So here I will select FALSE because my focus is one exact match which becomes =VLOOKUP[N1,N6:09,2, FALSE]
So by following the above-given step by step process using VLOOKUP in Excel you will get your value as an answer easily without any trouble
So that’s it by following the step by step procedure in our blog you will understand How to use VLOOKUP in Excel and now you can do it easily on your own without any hesitation. So start practicing now and if you have any doubt then feel free to comment us I will be glad to help you out.