QUERY ASKED IN GROUP

Key Takeaways

how to do with vlookup so are you able to see my screen clearly okay guys are you able to see my screen clearly let me know so that i can do some changes if it is not there okay i'll start it i'll start it i don't know but i'll start it okay so this is very very important right so i will do with windows see how i'll do first of all before going to this this is the uh say some names are there some names are there so you have to get these values as per this like this one two three four five for rahul if you do direct to vlookup it will pick up the first occurrence see it will do like this pick up the first occurrence f4 comma two or three or whatever or zero okay so it will pick up only the first occurrence no i don't want like this i want two three four five okay before going to start this session i will explain one thing first of all what we need we we look up two three four five six right from starting two to six again two to six again two two six again two two six two three four for vlookup see how i'll do here first of all the formula in h4 so it's dollar for column h4 i'm locking the row but not the column right okay so it will give all the serial numbers from one to still where you drag that is 16. so what i'll do simply i use minus one i'm showing the step by step double so you got 0 2 okay 0 to 15 now what i'll do the mod will give you the reminder okay if it is divisible it will give a reminder so what i'll do i divide with 5 why is 5 because here 5 are there 1 2 3 4 5 so for that reason i am dividing with 5 can see what will happen now it will give you the zero one to see wherever it finds there f5 it will give the zero zero zero zero zero okay now f2 are simply two three four five six i simply have two two three four five six two three four five six two three four five six okay two three four five six if you want you can check it two three four seconds just i copy this formula from here control c maximum people will not do with this okay sorry i delete this one is equal to control b instead of uh h4 i'll use l4 here l4 okay not h4 l4 you'll show the same thing or able to see the screen hmm at all where it is online i don't know what the problem it is now okay now are you able to see my screen yeah yes okay now see here i l4 l okay l4 see here is the difference previously i use here 80.4 here i use the l dollar four to l4 okay butterfly enter double two three four five six two tmc yes i kill this the cell address from here see the wherever the formula is there in that place i logged only the row but not the column okay you know did you got my point which i'm going to explain you so simply i use vlookup of rahul comma the whole table f4 comma and this will be the column index number that is 2 comma 0 enter it's not an array formula it is normal formula if you want sure it will do one thing so the second tourist for two red second values 21. for 2 second value 2 3 second value 21 second value 31 did you got it with the vlookup i did did you got it if you got my this thing any doubts no clay bro no i got it no with the vlookup i did okay yes bro okay some problem with this i'm closing i don't know some problem i'm closing it okay bye brother