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

#vlookup formula in excel this video will teach you how to apply #TextJoin formula with #ifformula in excel so you can populate multiple value for one single unique item. you can even skip #IndexMatch formula.
****************************
Download Link :- drive.google.c...
**********************
Don't forget to subscribe my channel get more related video notification. SUBSCRIBE - / @gyanontube
****************************FOLLOW ON************************
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
KZbin- / @gyanontube
Follow me on Instagram :- / gyan_on_tube
________________________________
How to use Xlookup in excel 😮 || xlookup formula in hindi 😮|| vlookup formula in excel :- • How to use Xlookup in ...
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :- • Array formula excel ||...
xlookup in excel in hindi || Xlookup A to Z in details || New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel || Xmatch formula in excel in hindi || Xmatch with Index formula:- • Xmatch formula in exce...
filter formula in excel || how to use filter formula in excel in hindi 😮 filter formula in hindi :- • filter formula in exce...
Top 10 excel formulas 😮|| excel formulas and functions || excel functions and formulas :- • Top 10 excel formulas ...
How to use excel unique function || Excel unique formula in hindi || Remove duplicate values:- • How to use excel uniqu...
Drill Down in Pivot table excel || Classic Pivot table view in hindi :- • Drill Down in Pivot ta...
3D Pivot Graph in excel in hindi || Lean Pivot from beginner to advanced || lean pivot table:- • 3D Pivot Graph in exce...
excel slicer || how to use pivot table slicer || slicer in excel 2007 and above :- • excel slicer || how to...
advanced pivot tables || advanced pivot table excel || IF formula in Pivot :- • advanced pivot tables ...
Sort formula in excel || array formula in excel || how to use sort formula in excel :- • Sort formula in excel ...
share excel workbook || excel shared workbook || excel tips and tricks :- • share excel workbook |...
pdf to word || convert word to pdf || ❌No software ❌No online convert pdf to word ***FREE** 😮 :- • pdf to word || convert...
Array formula excel || array function in excel || Excel Vlookup ❌|| index Match Excel ❌ :- • Array formula excel ||...
interview questions and answers || interview questions || advanced Excel || Excel Interview #7 :- • interview questions an...
google translate :- google translate english to hindi :- google translate in hindi :- • google translate :- go...
advanced excel :- Top 5 Advanced excel and word tips and tricks :- excel formulas in hindi :- • advanced excel :- Top ...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 3 :- • Job Interview Question...
Job Interviews question !! Excel interview question in Hindi !! Job Interviews question part 2 :- • Job Interviews questio...
Excel Interview Question 😮 MIS Interview Question in Excel in Hindi 😮 Excel Interview :- • Excel Interview Questi...
3D Glass Chart in hindi 😮 3D graph in hindi 😮 3D Excel Graph :- • 3D Glass Chart in hind...
Interview question how to get first and last name in excel 😮 First and Last name in Excel in Hindi. :- • Interview question how...
Serial Number auto populate 😮सीरियल नंबर औटो पॉपुलटे कैसे करें 😮rows formula to populate serial no :- • Serial Number auto pop...
Nested IF V/S IFS 2019 !! 😮😮 How to use #IFS formula 2019 with Nested IF :- • Nested IF V/S IFS 2019...
Fuzzy Lookup in hindi !! how to use fuzzy lookup in excel in hindi.😮😮:- • #Fuzzy Lookup in hindi...
How to Hide formula in Excel in Hindi 2019 😮😮!! Formula hide in Excel 2019 😮 :- • How to Hide formula in...
Window 10 Top hidden tricks 2019 👍 Windows 10 tricks 😮Windows 10 Hidden Features :- • Window 10 Top hidden t...
How to Change Excel background color In hindi ! office 2019 :- • How to Change Excel ba...
Advance Excel - Top 5 Excel Time Saving tricks 2018-2019 :-
• Advance Excel - Top 5 ...
Useful Excel trick for Biggner and Expert :-
• Useful Excel trick for...
How to Separate all text available in a cell :-
• How to Separate all te...
Macro Coding for Auto-fit cells in Excel :-
• Macro Coding for Auto-...
One Vlookup Multiple Worksheets :-
• vlookup in excel !! बह...
How to unlock Protected Excel sheet without Password :-
• How to unlock Protecte...
INDIRECT with Sum formula in Excel :-
• INDIRECT with Sum form...
*************************************(Gyan On Tube)********************************

[@DilseStatus]

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

[@GyanOnTube]

Thank you so much

[@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

[@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

[@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..

[@merapatients85]

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

[@GyanOnTube]

Thank you so much

[@onlyexcel493]

Sir aap formula ko bahot badhiya manipulation karte ho

[@GyanOnTube]

Bahut bahut sukriya Nileshgiri goswami ji

[@hiteshchourey9730]

Sirji, best formula.

[@GyanOnTube]

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

[@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

[@nareshbhagmal]

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

[@GyanOnTube]

Sukriya Naresh Mawana ji..

[@ravikumarbharti7174]

Wow! It's really helpful in excel

[@GyanOnTube]

Thank you so much Rahul.

[@ishwarsingh881]

Excellent trick.

[@GyanOnTube]

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

[@akashthakur5615]

Awesome vedio sir please keep it up

[@GyanOnTube]

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

[@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..

[@mohammadilyas2240]

Excellent زبردست From Pakistan

[@GyanOnTube]

Thank you so much

[@parmodkumarnnm]

Very nice video

[@GyanOnTube]

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

[@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

[@sureshkamath2988]

Thank you. It is very useful

[@GyanOnTube]

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

[@y.....1776]

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

[@yashparmar7387]

Superb

[@GyanOnTube]

Thank you so much...🙏🙏

[@Miahs8]

Problem solved, keep it up!

[@GyanOnTube]

Happy learning 😊

[@ravikumarbharti7174]

I learned new ways in excel from u

[@GyanOnTube]

Thank you so much for your valuable comment 🙏🙏

[@rakeshnamdev81]

This is Amazing

[@GyanOnTube]

Thank you so much

[@huzaifahuzi6877]

Great 👌👍

[@GyanOnTube]

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

[@rabin3333]

Amazing sir jii 🙏🙏🙏

[@GyanOnTube]

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

[@rabin3333]

@@GyanOnTube sure sir

[@abhishekdivedi1940]

Very good knowledge for me

[@GyanOnTube]

So nice of you. thanks for watching

[@hiteshchourey9730]

Sirji, better formula I like this.

[@GyanOnTube]

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

[@jaik570]

Excellent sir 👍👍👍👌👌👌👌

[@GyanOnTube]

Thank you so much for your valuable comment

[@onlyexcel493]

Good morning my dearest sir

[@bivekmallik867]

supab..amazing and very helpful for me

[@GyanOnTube]

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

[@kapishbhatia6935]

Woow buddy..... maza agya

[@GyanOnTube]

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

[@archanasingh259]

Awesome video sir

[@GyanOnTube]

Thank you so much ..

[@silajitdey1760]

Amazing! Simply *SUPERB* !

[@GyanOnTube]

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

[@morninggraphics2052]

Zabardast

[@GyanOnTube]

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

[@TheSantuja]

Jaduuuuuu

[@GyanOnTube]

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

[@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

[@puspenderkumardubey1732]

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

[@GyanOnTube]

Sure iske upar bahut jald aapko video milegi

[@puspenderkumardubey1732]

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

[@RohitKumar-cc7zi]

Great to see for next level thanks lot 👍👍

[@GyanOnTube]

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

[@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

[@srikantmahato1791]

Great brother

[@GyanOnTube]

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

[@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.

[@pkinfo79]

Great work bro

[@GyanOnTube]

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

[@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

[@rahulvishwakarma2119]

nice sir

[@GyanOnTube]

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

[@rakeshchaudhary1110]

Aowsome

[@GyanOnTube]

Bahut bahut shukriya 🙏🙏🙏

[@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..

[@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..

[@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.

[@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

[@v.sintrestingvideo500]

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

[@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

[@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..

[@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..

[@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..???

[@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

[@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

[@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

[@jaik570]

Duplicate kaise hatayenge sir

[@GyanOnTube]

Text to column kar do aur remove unique

[@SuckMyGreasyPrick]

Better formula to use: =TEXTJOIN("_",,FILTER(C:C,A:A=F2))

[@GyanOnTube]

thanks

[@tulsiliveinfo333]

मेरा एक्सल 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

[@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

[@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

[@deepaksinghbhadoriya8077]

Amazing ❤

[@GyanOnTube]

Thank you so much 🙏