 Hi friends, welcome to SS Unity. My name is Susheel Singh and this is a continuation of Excel tutorial. So today we will discuss about index and match function which is available on Excel. So let us move to another slide where I have created a scenario by which we can apply index and match function to get the output. So this is our slide as we can see we have 2 input seeds. Seed 1 contains 3 columns. First is item code then description and quantity. we have totally different scenario so we look up is not going to provide any facility by which we can apply we look up if the common columns are available on right hand side so on that scenario we have to apply index and match function to get the output so let's move to excel so we can write formula and we can get the output so first of all we need to discuss about the index and match function what match function does we are going to use match so match it takes three parameter first is look up value so first of all we need to specify the look up value by which we want to get the index and match function will return the index from where that look up value is available on that array so here we can see we want to get index of this b so we can specify b and then we have to specify the look up array so this is our look up array by which we want to get the index where b exists and then third parameter is optional parameter I am going to put 0 and then we can simply put enter so here we can see it's going to return 3 so here we can see it's going to calculate from 1 and then it will match b it's not present in first then move to second and then third so it's available on third position so it will return third and then the index so index so first of all we need to specify the array by which we want to get the value so this is our array and then we have to specify the row number by which we want to get the output so we want to get the output of fifth row and then we can simply put enter so here it's going to return D as we can see our fifth row contains D over here so this is our index and this is our match so I hope you have understand how we can apply match and how we can apply index so let's move towards scenario so this is our second seat and this is our first seat so we want to get the quantity so first of all we need to apply match function to get the index so this is our look up value and then put comma and go to our second seat and we want to get from here so we have to specify and then put comma and then zero and then enter so it's going to return the index from where item code exist in our second seat and then we can apply index so this is our index and then we want to get the values from quantity column so we have to select quantity and then put comma and go to department seat and in department seat we want to get values from this index column so we have to select that one and put comma these are the optional parameters so we can skip and we can simply close the bracket and put interest so it's going to return eight and then we can scroll and we can see so this is our five ten four fifteen and not applicable so here we can see this quantity value and this quantity value both are same so I hope you have understand how we can get the output thank you so much for watching this video if you like this video please subscribe our channel to get many more videos thank you so much