MNC COMPANY INTERVIEW -7

Key Takeaways

hi friends how are you all here Excel Guru rajinikant and this is the one phaal company interview question so before going to start I will explain you you have to do so watch till end because you will come to know you'll understand that why I'm using this type of functions where I am using why I am using all those things I will explain if you skip you not able to understand and one another thing is that please like share and subscribe my channel now I'm sharing the solution the screen here is the screen okay I'll explain you what it is so here is the the interv ask here in in this range you will have three things one is product ID another thing is product and another thing is expir data and he said that whenever you change a product ID or a product automatically the expir date should display okay see an is there March 24 is there is there March 24 is there if I change to product three p 3 so it has to come January 25 okay so I will use Doo so it has to come j 21 okay I'm using Excel 365 then also I'm explaining in Excel 2010 functions and this is an array function you have to use control shift and enter after entering the formula right see here is the formula I'm going to show you first of all what you'll do I'm saying that search of Doo comma in this R okay close parenthesis so wherever it finds the do the position it will show you true or falses remaining it will show you the error value error okay see the sixth position is in dualo okay remaining it is not found so it's showing value errors okay I will enter and here I will show you another thing that I will use PR three so it has to show one see in third position it is one okay in third position it is one are you able to understand what I mean to say and here coming back to the formula what I use I need numbers okay I need numbers is number and and I want to errors if I use e number it will pick up number as true and remaining errors or whatever it may be it show show as falses I'm using by we look up I'm okay this is EAS number okay F9 C wherever it find the number it will pick up the true and remaining are all falses okay done now I use this choose function here okay I'll do what I'll do I'll remove I will copy that one what I'll do here I use a mid function and what is the delimer here I ENT not here you have to substitute here substitute of M substitute of Hy the text will be Hy and select the range okay s the range now comma what will be the old text the old text is hyph sorry the old text will be the hyph okay and the new text I'm adding repeat of space 255 times okay close parenthesis and starting number what I'll use I use a three because I need three right expir rate I need so I use three into 255 comma 255 okay I press F9 so it will display all with Extra Spaces and it will remove all hyph F9 so we need expir dat only it is there so what I'll use they I will remove Extra Spaces by using a trim function over here okay understood F9 c contrl z contrl c I'm copying that's it enter now I'll come back to this formula once again and here I used a choose function choose of 1 comma 2 so because I need two things one is condition condition and another thing is desired output this one just I copied from this close parenthesis now what will happen by pressing F9 we will come to know see what I said we want to use a v lookup only not other other than functions okay so what I'll use here I use a v lookup over here two comma I'm look uping the true the Lo value is true comma 2 comma 0 it's an array function I'm using Microsoft 365 for that reason I'm using only enter it can it will understand if you are using 2010 then you have to use control shift and enter okay see here if you change anything over here like Pro for pro four automatically it will display March 24 and it will not change because Mar is De is the correct answer so it will not change January 21 again Pro two so it has to Jan 22 understood what I mean to say thank you guys thanks for your support I'll I will be back with another MNC company interview questions please like share and subscribe after watching this video you can able to crack any sort of M interviews easily