Finding rate with 2 conditions by using vlookup

Key Takeaways

hi friends this is rajinikanth excel guru and here this is the query asked in facebook to find the rate as per two condition that is section id and the code this is section and this is the section this is a section and this is the code without helper column we have to find the right by matching this section and code you have to get this rate by matching these both things section and code you have to get this set by using vlookup and without helper column so here is the solution for that so how you will do this one first of all whatever what i'll do is i'll explain you step by step if you have any doubt ask me in the comment box or in my group okay in below of this video i'll mention my group telegram group you can join and ask the doubts and queries about excel and here now coming back to this querying here is the solution however to do okay so first of all what i'll do here first of all i will find is anything one second is anything wait a minute equal to in this section i'm locking every set and this is a boolean logic and this equal to code f4 okay this is the two conditions these are the two conditions first one you have to find how many sections are there in this data and the second one is how many codes are this there in this data so if i press f9 to evaluate and let us check whether width is smacking first of all before going to f9 i will show you step by step first of all i press enter f2 i highlight this thing f9 true false to wherever it finds this code over here in this section it will show us the true and remaining are all forces the same procedure here f9 wherever it finds this code over here it finds the true and remaining are all falses so true into true that is one falls into true that is zero falls into two zero two into false zero falls into false zero falls into false zero fault is considered as a zero and two is considered as a one in boolean logic right so here i will explain you now so what you have to do you have to use a choose function that is flower bracket i am giving two conditions because whenever it matches this uh this one over here wait a minute i will show you i think and i press f9 c1 so it matters only one remaining or all zeros it is one for zero it is one for zero it is zero for zero here see it is it is like a table over here okay it's like a table so control green you