New vlookup formula in excel || textjoin function in excel || index match function in excel

[@pramodbhavsar4488]

Sir aapne bahuthi achha video formula lekar bananaya hai uskeleye i thank you Mai aapke video ka inte jar karta hu or aapki mahenatki kada Marta hu

[@GyanOnTube]

Aapke itne aache comment ke liye bahut bahut sukriya..aap logo ke liye hi mein khoob mehenet karke ese videos bana pata hu..

[@pramodbhavsar4488]

@@GyanOnTube thank you sir

[@DilseStatus]

Thanks sir mujhe is formule ki bahoot jarurat thi 🙏🙏🙏🙏🙏

[@GyanOnTube]

Thank you so much

[@onlyexcel493]

Sir aap ne bilkul fact bataya tha ki gyan ko expand karne se hi gyan badhta he... 100%Right sir.. Realley sir please believe me.. you are unique to us..

[@GyanOnTube]

Nileshgiri goswami ji...your all comments really means a lot to me.. thank you for all your support and help..

[@rahulcomputercentre2463]

सर आप का आभार आप बहुत सरल वीडियो बनाते है,

[@GyanOnTube]

Bus rahul ji aap logo ke comments se hi mujhe hosla milta hai jiske karan mein esi videos bana pata hu.. thanks for all your support..

[@onlyexcel493]

Sir aap formula ko bahot badhiya manipulation karte ho

[@GyanOnTube]

Bahut bahut sukriya Nileshgiri goswami ji

[@muhammadsaqlain5162]

Very amazing tricks kamal hai super se bhi uper hai ye video.

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@merapatients85]

Mind blowing tricky creative formula amazing knowledge and basic concepts great sir ji keep it up knowledge

[@GyanOnTube]

Thank you so much

[@ashoksahu9546]

Sir really you are great. Nice Trick sir . Thank you so much.

[@GyanOnTube]

Thank you Ashok ji..keep sharing the videos and keep supporting

[@y.....1776]

सम्यक् मित्रं ... जयतु भारत.... इति अपक्षेया गुप्त योजना दर्शयतु नवीनं चलचित्रे निर्माणे

[@dildars1]

Mind blowing formula I have ever watched.....

[@GyanOnTube]

Thank you Dildar Singh ji...aapke comment ke liye bahut bahut sukriya...keep sharing keep learning

[@ravikumarbharti7174]

Wow! It's really helpful in excel

[@GyanOnTube]

Thank you so much Rahul.

[@hiteshchourey9730]

Sirji, best formula.

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@ravikumarbharti7174]

I learned new ways in excel from u

[@GyanOnTube]

Thank you so much for your valuable comment 🙏🙏

[@sureshkamath2988]

Thank you. It is very useful

[@GyanOnTube]

Thank you Suresh Kamath ji.. bus esee hi support aur pyar banaee rakhna..

[@mohammadilyas2240]

Excellent زبردست From Pakistan

[@GyanOnTube]

Thank you so much

[@ishwarsingh881]

Excellent trick.

[@GyanOnTube]

Thank you so much Ayushman ji.. keep sharing keep learning

[@hiteshchourey9730]

Sirji, better formula I like this.

[@GyanOnTube]

Thank you so much...do not forget to share this video

[@onlyexcel493]

Good morning my dearest sir

[@akashthakur5615]

Awesome vedio sir please keep it up

[@GyanOnTube]

Thanks a lot Akash Thakur ji.. please share this videos with your friends as well..

[@Miahs8]

Problem solved, keep it up!

[@GyanOnTube]

Happy learning 😊

[@abhishekdivedi1940]

Very good knowledge for me

[@GyanOnTube]

So nice of you. thanks for watching

[@bivekmallik867]

supab..amazing and very helpful for me

[@GyanOnTube]

Thank you so much..do not forget to share this video is

[@silajitdey1760]

Amazing! Simply *SUPERB* !

[@GyanOnTube]

Silajit Dey ji..thank you for your valuable comment...keep supporting and keep learning..

[@parmodkumarnnm]

Very nice video

[@GyanOnTube]

Thank you so mcu for your valuable comment..keep sharing keep learning

[@rakeshnamdev81]

This is Amazing

[@GyanOnTube]

Thank you so much

[@rabin3333]

Amazing sir jii 🙏🙏🙏

[@GyanOnTube]

Thank you Robin... please share with your friends and family and keep supporting..🙏🙏🙏

[@rabin3333]

@@GyanOnTube sure sir

[@yashparmar7387]

Superb

[@GyanOnTube]

Thank you so much...🙏🙏

[@nareshbhagmal]

super se upar !!!!*****!!!!!

[@GyanOnTube]

Sukriya Naresh Mawana ji..

[@jaik570]

Excellent sir 👍👍👍👌👌👌👌

[@GyanOnTube]

Thank you so much for your valuable comment

[@ashoksahu9546]

Sir how much will appreciate you, I think it will be less for you. Really sir this video is fantastic.

[@GyanOnTube]

Your comment really means a lot to me..thank you so much for all your kind words ❤️..keep sharing the videos with your friends and who so ever want to learn office 365..

[@ashoksahu9546]

Sir kindly give your mobile number.

[@ashoksahu9546]

Sir I want to talk with you. Sir please send your mobile number. Please sir.

[@GyanOnTube]

@@ashoksahu9546 ji..i cannot share my number over youtube..hope you understand the reason as KZbin is worldwide and any one can read the comment...however you can join my telegram group and chat directly.. @Excelinhindi

[@kapishbhatia6935]

Woow buddy..... maza agya

[@GyanOnTube]

Thanks 😊 kapish..your comment really means a lot...keep supporting and keep learning..😊

[@huzaifahuzi6877]

Great 👌👍

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@RohitKumar-cc7zi]

Great to see for next level thanks lot 👍👍

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@maithilnitesh]

This is really superb vedeo I have ever seen, today I got chance to learn something new from this vedeo, Thanks a lot. Sir I just wanted to know can we use this formula in excel 2016 or before.

[@GyanOnTube]

Thank you so much Nitesh Mishra ji..yes u can use that..if you have textjoin function in your excel then you can definitely use this Formula.

[@archanasingh259]

Awesome video sir

[@GyanOnTube]

Thank you so much ..

[@Samriddhi1020]

Is there any alternative TEXTJOIN as it is available in office 365 only . Awaiting your reply on this

[@GyanOnTube]

Yes we can use this by contact formula as well..i have prepared a video on that as well..

[@Samriddhi1020]

@@GyanOnTube would you please share link of video where you have putted contact formula in place of TEXTJOIN

[@GyanOnTube]

kzbin.info/www/bejne/rIfCYmCQnN2snqc

[@Samriddhi1020]

@@GyanOnTube not getting right result . only one cities name is populated same as vlookup I was trying to learn this formula but not getting exact result what have you shown in your video

[@GyanOnTube]

Might be you are missing some point watch end to end video..

[@morninggraphics2052]

Zabardast

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@deepaksinghbhadoriya8077]

Amazing ❤

[@GyanOnTube]

Thank you so much 🙏

[@BalvirSingh-qs9kz]

Sir, very nice. Thanks, sir, city name unique column (heading) ho or name city name ke neeche filter hokar aa Jaye. Next video yesa banaye. Thanks

[@GyanOnTube]

Sure

[@pkinfo79]

Great work bro

[@GyanOnTube]

Thanks pk info.. please share my videos with your friends and family..those who want to learn excel..

[@srikantmahato1791]

Great brother

[@GyanOnTube]

Thanks Srikant mahato ji... please is video ko aapne friend and family ke sath share zaroor karna..

[@puspenderkumardubey1732]

दो अलग-अलग sheet के डेटा को match करना बताइये कृप्या

[@GyanOnTube]

Sure iske upar bahut jald aapko video milegi

[@puspenderkumardubey1732]

@@GyanOnTube धन्यवाद सर

[@rahulvishwakarma2119]

nice sir

[@GyanOnTube]

Thank you so much..do not forget to share this video

[@SanviPatil2019]

Sir kya text join ki jagah concatenate formula hum use kr sakte hai,,kaisi batai

[@GyanOnTube]

Vikas supereb question...i really like your questions..thank you for raising this question...ji ha bilkul kar sakte hai concatenate Formula se..aapke liye mein ye videos zaroor leke aaunga bahut jald magar isme ek problem hai 2 value ke bich mein space nhi aaega.

[@SanviPatil2019]

@@GyanOnTube thanks sir

[@GyanOnTube]

Vese mene bana diya hai aap ke liye formula with space and its working...iski video leke aata hu bahut jald...can i show your comment on my video..???

[@SanviPatil2019]

@@GyanOnTube why not sir...

[@GyanOnTube]

Thank you..very soon will make this videos with your comment..

[@TheSantuja]

Jaduuuuuu

[@GyanOnTube]

Sukriya Santanu bhattacharjee ji.. please keep supporting and keep sharing.

[@pramodbhavsar4488]

Sir isme massage bhejte samaiper word change hote his isliye sort firbhi aap mery bhavna per dhyan rakhe

[@GyanOnTube]

Samaj gaya Pramod bhavsar ji bilkul samaj gaya..aapka bhaut bahut sukriya..🙏🙏🙏🙏

[@pramodbhavsar4488]

@@GyanOnTube thank you sir

[@v.sintrestingvideo500]

Mujhe aapse VBA macro sikhana hai... please reply me

[@rakeshchaudhary1110]

Aowsome

[@GyanOnTube]

Bahut bahut shukriya 🙏🙏🙏

[@sachinKumar-ow9sl]

Sir I found an error at excel while changing the source at pivot table stating "There are too many records to complete this operation" and that's way I am unable to my work accordingly so please help me...

[@GyanOnTube]

Please check how much data do you have..???

[@dipteesingh9492]

Last mai normal enter ki jagah clt±shit+enter kayu press kiya? Sirf enter press karne se value nahi ayegi?

[@GyanOnTube]

Normal click karne se nhi aaega..kiyoki humko formule ko array function banana hai isliye ctrl+ shift + enter kiya hai..

[@onlyexcel493]

Sir agar first column me repeat name ho to hum VLOOKUP through hamara answer fetch karke kese laye

[@GyanOnTube]

Nileshgiri ji agar first column mein repeat name ho to aapka Vlookup work nhi karega..uske liye aapko =textjoin with if Formula hi lagana hoga.

[@onlyexcel493]

Sir agar hum isme ek helper column COUNTIF ke through nikalke VLOOKUP lga sakte he kya

[@onlyexcel493]

Sir I am going to my office.. Bye.. Take care..

[@GyanOnTube]

@@onlyexcel493 usme bhi Vlookup aapko sirf ek hi answer nikalke dega...agar aapko multiple answer nilkalna hai to aapka Vlookup work nhi karega count ke Formule ke sath bhi.

[@ravitkumar6920]

Whether textjoin will work in excel 2016

[@GyanOnTube]

Ravit kumar , text join will not work in office 2016..for all of you i prepare another video with concatenate which will give u the same result... kzbin.info/www/bejne/rIfCYmCQnN2snqc

[@ravitkumar6920]

Sorry it is not working it is picking up only first value

[@ravitkumar6920]

Pl help me it is not working

[@ravitkumar6920]

Can I contact you over phone

[@GyanOnTube]

@@ravitkumar6920 its array formula please press control + shift + enter

[@hamSo47]

Sir, I didn't understand why we press Ctrl+Shift+Enter. Could you please explain..?

[@GyanOnTube]

That is because of array.. to make the same formula in array...try yo apply the same formula without crtl + shift + enter and check is it is working..

[@prashantpanjabi5656]

Hello Sir This is really very nice video But tell me How to use Textjoin function in ms-excel 2010

[@GyanOnTube]

Thank you so much... however you will not get textjoin in 2010 i will suggest you can upgrade to 2019 its free..

[@mohdabdullah452]

@@GyanOnTube sir kaise free 2010 ko 2019 m upgrade kre plzz bataiye

[@GyanOnTube]

Aap youtube mein dekh sakte ho bahut video hai isse related

[@mohdabdullah452]

@@GyanOnTube sir plzz aap ispr video banadiye vrna kisi acche KZbinr ka link dediye jisne ispe video bana rkhi h mne Kai baar KZbin pr search Kiya lekin nhi mila

[@GyanOnTube]

Ese mene check nhi ..but will check and let you know..

[@hrishitathe1947]

How can ignore the duplicates states. I can see Bhopal comes twice, want it only come once... How we can achieve it.

[@GyanOnTube]

Duplicate sheet means

[@p.narasimamurthy5353]

I have question regarding unique is same populate answer but unique it are different like wise 87888HUT but I'd is 788 how to match and populate the unique

[@GyanOnTube]

Very nice question Murthy ji..for this we need to use wild card option...you can check the below video for same.. kzbin.info/www/bejne/i362ZadqhtF9eZI

[@p.narasimamurthy5353]

@@GyanOnTube Thanks for replying my queries sir I am already try this but failure to extract correct results. in the data rows around 8000 to 15000 here what's the problem is wild card extract near by values like 74479 in the rows another values like 5474489 , 795667 it's wrongly placed value 2nd values

[@AbhishekMishra-cr1tz]

बहुत अच्छा है लेकिन यह वीडियो एक बार आप बना चुके है

[@GyanOnTube]

Abhishek ji thank you inform karne ke liye..ye knowledge aur ye formula mein jyada se jyada share karna chahata hu...taki sab ye Formula use kar paee..

[@AbhishekMishra-cr1tz]

@@GyanOnTube जब पहली बार देखा था और यूज़ किया था तब जितना अच्छा लगा उतना ही अच्छा आज भी लगा आप के वीडियो लाज़बाब होते है

[@GyanOnTube]

@@AbhishekMishra-cr1tz aapka tehe dil se sukriya ji..is video ko jitna ho sake utha share karo taki sab ye Formula use kar paee..

[@silajitdey1760]

I m 56 yrs old. Would you be please kind enough to teach me online?

[@GyanOnTube]

Sure i am preparing videos on weekly basis if u check and learn those videos u will be in the top of excel..

[@silajitdey1760]

@@GyanOnTube may I know your email address?

[@GyanOnTube]

@@silajitdey1760 i can not share my email address here hope you understand..you can join me on telegram group for live chat. @excelinhindi

[@jaik570]

Duplicate kaise hatayenge sir

[@GyanOnTube]

Text to column kar do aur remove unique

[@rajeevgosavi4514]

WHAT IS THE FORMULA FOR ADDING ALL SALES VALUES FOR A UNIQUE ID. HOW TO DO IT

[@GyanOnTube]

You can simply use sumif formula

[@dynamicelectricalssnb8552]

There are 500 Items, 100 customers indicated 20 different items in each inquiry for supply How can we add all (common Items) aggrigate in one vouher without showing the complete List of Items.

[@GyanOnTube]

I wm unable to understand your comment..can u please elaborate

[@tulsiliveinfo]

मेरा एक्सल 2019 में नया फार्मूला काम नहीं कर रहा है #Name Error दे रहा है

[@GyanOnTube]

Iske liye aapko office 365 Download karna hoga..ya aap kuch din ka wait karo Microsoft bahut jald isko roll out karne wala hai

[@rahulcomputercentre2463]

सर आप अपनी gmail id बताइये मेरा एक डाटा है excel मे एक कालम मे कई कोड है उन्हें अलग करना है प्लीज हेल्प करें. मै डिग्री कॉलेज मे काम करता हूँ l

[@GyanOnTube]

Rahul computer center ji...i ,can not share my email address over KZbin.. however aap mere telegram group join kar sakte hai aur aapna sawal waha pooch sakte hai.. @Excelinhindi

[@rahulcomputercentre2463]

सर मेरा email है [e-mail] बताइये अपना मै अपना डाटा अलग नही कर पा रहा हूँ, ताकि आपकी ईमेल मे हम अपना डाटा शेयर कर सके प्लीज

[@GyanOnTube]

@@rahulcomputercentre2463 sure ill reply back on email