 Hello friends, welcome to SSUniTech. My name is Susheel Singh and this is continuation of Excel tutorial. So, in this session we will discuss how we can get the values by using VLOOKUP when the common columns are more than one. In our last session, we have discussed how we can get the values by using VLOOKUP. But there was the different scenario. There was only one common columns are available between the seeds. But here we have more than one common columns by which we want to apply VLOOKUP and get the values. So, let's move to another slide where we will discuss what it means. So, this is our slide. As you can see, we have two input seeds. First contains four columns. First is item code second variant and then description and last column is quantity. As you can see here quantity column is blank. So, quantity is available in our another seed. Our second seed contains three columns. First is item code then variant and then quantity. So, by using VLOOKUP we won't get the values from our second seed to our first seed. But the common columns are item code and variant. If there is only one common column available between these two seeds then we can simply apply VLOOKUP as we have discussed in our last session. But here the totally different scenario. So, how we can achieve this? This is very important and Excel doesn't provide any facility by which you can apply the VLOOKUP when the common columns are more than one. So, there is a trick by which you can apply VLOOKUP and we can get the values. So, let's move to our Excel where we will discuss how we can get the value. This is our department seed and this is our item stock seed as I have discussed. First of all we need to add a column on these two seeds. We can simply add columns has been added successfully. I want to concatenate item code and variant code. So, we can concatenate simple by using equals to then item code and then we have to use m% in Excel to concatenate between the cells. So, this is our second cell. So, as we can see item code and variant has been concatenated successfully. So, this is our common column. So, we can call as column. In our item stock seed, we are going to use the same formula by which we can concatenate between item code and variant code. So, item code and variant has been concatenated successfully. So, now we can see there is only one common columns available between these two seeds. So, we can apply VLOOKUP and we can get the values. As I have discussed in our last session, if you haven't watched that session, first I would strongly recommend to watch that session. So, it would be very helpful to you understand how we can apply VLOOKUP. So, here I am going to use VLOOKUP. So, this is our VLOOKUP and then I am going to select the whole column which is common between these two seeds. So, then I am going to put comma. So, let's move to another seed where values are present. And this is our common column. So, we have to select this column and we want to quantity. So, quantity we have to select from this common column to our that column where the value has been present. So, this is our second column. So, we have to put comma and then two then comma and then simply zero and then enter. So, as you can see five and we can scroll down. So, we can see we can get the values which is present in item stock. So, five six one such type of values and here we can see five six one. So, it is very simple. We can first add a column between these two seeds and then concatenate the common columns which is available. If there is three common columns is available then we can simply concatenate between these three columns and then we can apply the VLOOKUP. So, I hope you have understand how we can get the values. If we delete this cell right now then we can see we will get an error. So, before going forward I would like to copy this cell and paste the only values. So, values have been paste successfully. Now, I am going to remove this column and we can see we are getting the result as we have expected in our slide. So, this is our slide and this is our output. So, both are same. So, I hope you have understand how we can apply VLOOKUP when the common columns are more than one. First you need to concatenate all these columns which is common between the seed by which we want to apply VLOOKUP. Then we can simply apply VLOOKUP because the values are present in our single column. If you like this video please subscribe our channel for many more videos.