Excel Vlookup Maharaj Part 1 | Vlookup with Concatenate and Iferror

[@pankajwankhade8067]

Interesting with multi example !...fabulas....explaination superb ! u r best guru for me

[@Innozant]

Thanks Pankaj Ji❤️

[@murlidhartiwari9776]

Happy Teachers day. You are the best teacher 🙏

[@salilpattanayak7726]

Entertaining series start, Best of luck sir, God Bless You

[@Innozant]

Thanks Salil Ji..Happy learning ❤️

[@manojkumarsingh3385]

" One book, one pen, one child, and one teacher can change the world."

[@Innozant]

❤️❤️

[@Pooja-bd7zm]

हर काम आसान हो जाता है, जब सच्चे शिक्षक का सनिध्य मिल जाता है, फिर चाहे कितने ही आये जीवन में उतार चढ़ाव, शिक्षक के चरणों में ही मिलता है ठहराव..... Happy Teacher's day Sir 💐💐💐

[@Innozant]

Thanks Pooja..God bless You dear..Happy learning..Have a wonderful career ahead

[@vishwaschavan7182]

Hyperlink + Vlookup was very innovative 👌

[@Innozant]

Thanks Viswas ji

[@1gopalakrishnarao]

Excellent. Very Informative. inspiring. Thank you on behalf of all my Excel friends/users/addicts/lovers.

[@Innozant]

Thanks Gopala..After long time ?😀❤️

[@parthahati2284]

I used hyperlink several times before but didn't know how to use hyperlink as a function. Sir our confidence level is getting high to higher day by day . #The_Best_Teacher

[@Innozant]

Thanks Partha..Happy Learning dear..God bless You

[@surendraclia]

great sir, your teaching skills is super🙏

[@Innozant]

Thanks dear

[@mr.psk.972]

Maja aa gya sir excited for next videos. keep sharing you knowledge.

[@Innozant]

Thanks dear

[@Goyalharsh420]

You are doing great job sir

[@moinusaifi3164]

Super se bhi uper 🔥🔥🔥

[@Innozant]

Thanks Moinu..God bless You.Happy Learning ❤️

[@situsahoo2482]

Greetings For the day Sir. Hum naye soch tarike ka sarahana Karna chahiye. Yea toh ban ta hai sir.I love Dilip sir and innozant channel.Happy learning with u. Happy Teachers day🙏🙏🙏

[@Innozant]

Thanks Sahi Ji.God bless you dear

[@pramodbhavsar4488]

Very nice concept of hyperlink with vlookup function with multi task thank you sir

[@Innozant]

Thanks Pramod Ji ❤️

[@mahenderbisht2700]

Great sir ji🙏

[@dileepmathulkar6516]

Very nice and anything regarding vlookup: Welcome Sir !

[@Innozant]

Thanks Dileep Ji

[@ashishshiriskar123]

Sir you are always superb 👍👍👍

[@Innozant]

Thanks Ashish ji

[@sameenarafiq1339]

Nice informative tutorial.... Thank you so much for uploading..

[@Innozant]

Thanks Sameena..Good Morning..Have a wonderful career ahead..God bless you dear.❤️

[@arunkumarsahu4938]

Existing next video & hayper link 👌👃

[@insidehead]

Gajab hai sir aap. 👏👏

[@Innozant]

Thanks Vinod ji

[@insidehead]

Sir interview questions honge aapke pass jise hum practice kar sake. Aur job interview crack kar sake .

[@sandeepaswal8944]

Wish You Happy Teacher Day My favourite Teacher 👏❤❤ Awesome Video❤❤

[@Innozant]

Thanks Aswal Sahab..God bless You

[@rahildalvi878]

Happy teacher's day sir💐💐💐👍🏻

[@Innozant]

Thanks Rahil

[@cartoonloversop6019]

सर मेने आपके विडियो से बहुत कुछ सीखा हे तो आप मेरे टीचर हुऐ और आज आपको कैसे भूल सकते है सर आपको आज के टीचर डे की बधाई Thanks for Teach us 🙏

[@Innozant]

Thanks dear..God bless You

[@L.mkidifrentlife1435]

Sir jee maine datedif function use kiya aur aapne jaisa btaya ta bilkul vaisa wo work kr rha h thanku so much

[@Innozant]

Very good Dolly...Good Night..saaree playlist step by step revise bhi krte rehna hai

[@L.mkidifrentlife1435]

Hmm thanku sir gud night sweet dreams

[@Radhe.mahant2010]

Great man have a great videos as you are.

[@Innozant]

Thanks Radhe

[@ishutiwari5567]

you are a great teacher sir. happy teachers day❤️

[@Innozant]

Thanks dear..God bless You

[@anushreeshah9239]

Happy Teachers Day Sir🙏🏻

[@Innozant]

Good Morning .. Thanks Anushree..God bless You dear

[@arbazahmad7177]

Great 👍 sir

[@TheSuvankarKundu]

Sir, you are the best

[@Innozant]

Thanks

[@sathyanarayana4914]

Very beautiful vedio sir

[@asmrindia]

Very Beautiful Sir, Thanks

[@Innozant]

Thanks Amit

[@createyour6681]

Very great sir

[@Innozant]

Thanks dear❤️

[@hsgusain2054]

Excellent Sir... thanks

[@Innozant]

Thanks

[@iamsainipawan]

Happy teachers day we all ❤️you sir please keep spreading knowledge and experience with your students and learners god bless you sir aap Khush rahe swasth rahe yahi hi hamari kaamna hai bhagwaan SE 🙏👍 happy learner

[@Innozant]

Thanks Saini Sahab..God bless you dear❤️

[@RahulChauhan-ll9pu]

Happy teacher's day 💖💓💗💕💛😘💖💓💗💕💛😘💖💓💗💕

[@Innozant]

Thanks Rahul..God bless You

[@satishojha6240]

Trimandous video sir 🙏🙏🙏. good night

[@Innozant]

Thanks Satish Ji .Gn

[@deepali303]

❣️Happy Teachers Day❣️, Sir. For some reasons i am unable to continue my learning in this field but i will necessarily restart it... You are amazing ,Sir. Thanku very much for guiding .🙌🙌

[@Innozant]

Thanks Deepali.. Why dear ?Now you are in some other field ? If yes still I recommend you to nerver stop your learning. whenever you have time make yourself free to learn.It will help you ok near future

[@excel1173]

Thank you sir

[@RahulChauhan-ll9pu]

Great 👍

[@Innozant]

Thanks ❤️

[@mdibrahimsheikh1680]

Thanks Sir....

[@bhoopendraraghav9781]

Love u always god bless u sir g

[@Innozant]

Thanks Bhoopendra Ji.

[@bhoopendraraghav9781]

@@Innozant गुरु का स्थान सबसे उंचा, गुरु बिन कोई ना दूजा Happy teachers day

[@pradeepjangid490]

Happy Teacher s Day Sir

[@Innozant]

Thanks Pradeep God bless you

[@kishorpanara4191]

Awesome dear sir thank you sir

[@Innozant]

Thanks Kishor ji

[@nirmalankur]

Need help on combining columns and then vlookup to get my answer without duplicates, also the column position changes when we get new entries in raw data....what do you suggest? I want it to be dynamic so that even if column position changes the formula should not throw an error. (I cannot use column header as vlookup value, as I have to combine multiple columns to get the actual vlookup value)

[@Innozant]

Kindly share your excel sheet with query explanation @ telegram id

[@RohitKumar-uy7cx]

Wow Sir ji

[@kishanmishra9611]

Fabulous sir.. 🙏

[@Innozant]

Thanks dear

[@RahulRoy-po9ct]

🙏

[@tejpalsain1507]

Thanks for it

[@sravi991]

Request a tutorial like this for :- (hyperlink - goto cell a1) :- 1st sheet = index sheet 1st cell = total no. Of sheets. Col to list sheet no. 1 to n.. with names. When any sheet renamed, sheets name in d index sheet to change dynamically. Next col. To have hyperlink formula to go to the selected sheet. Using excel 2017.....

[@Innozant]

Use it with wildcard and indirect

[@ujjwalgarg6436]

👍

[@saikiransriramoju4600]

Happy teachers day sir

[@Innozant]

Thanks

[@rhashmi1]

Excellent

[@Innozant]

Thanks Rashid sahab

[@sadashivkage3133]

TQ....sir

[@durgeshrai8938]

🙏🙏

[@Innozant]

Thanks

[@anuragkaushik8759]

Sir happy teachers day

[@Innozant]

Thanks Anurag ji .God bless You

[@sekharispassion]

Sir, Great explanation. I have a doubt, how to hide formulas keeping the hyperlink in first case. If you have already explained in your previous videos please share the link. Thank you.

[@sekharispassion]

Sir, Found your 9 months old security video on hiding formulas. Downloaded your practice workbook and implemented your hide formula explanation. It worked. Thank you once again.

[@ishutiwari5567]

sir aapne office 365 purchase kiya hai ya fir aap ms office ki official website se login krke online ye functions use krte ho?

[@Innozant]

Licencee version hai Ishu

[@manojkumarsingh3385]

Guru Govind Dono Khade Ka ke lagu PAYE Bali Hari Guru Aap ne Govind Diyo Bataye Happy Teachers day Sir Ji 🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks Manoj..God bless you bacha..Happy learning..Have a wonderful career ahead

[@er.rehanmalik2150]

Sir, I need your help. Actually I have a excel sheet of survey done details date wise mentioned in it and I have 11 survey teams. I want to add a formula in an incentive column as like, on same date if a survey engineer surveyed more than 3 surveys then he get 100rs incentive for his 4th survey and then 5th survey and so on. If he did survey 1, 2 or 3 then no incentive given to him. Which function I have to use?

[@Innozant]

Share your Excel sheet @ innozantofficial telegram id..will see

[@er.rehanmalik2150]

@@Innozant Yes. It's shared.

[@sabduljabbar5026]

Sir if we have 12 months data and by pivot table can i get month and cumulative data in the same column down by down. I have consulted through telegram also but I have not got any reply. I have asked many queries but I haven't got any exact answer from telegram sir. Please reply

[@sravi991]

Good. Now, I list out sheet names manually in d index sheet. Can it be listed automatically? 2) when I rename any sheet, index sheets name list must also change accordingly. Kindly produce a video with just hyperlink hyperlink to jump.

[@pa2happiness13]

💞👌🏼

[@Innozant]

Thanks

[@DailyUpdate2k24]

Sir ek hi bar me kae column me vlookup kese lagaye .age hame ek bar me se hi sabhi coloum Ka details lana ho to

[@manojkumarsingh3385]

You are great 🙏🏻🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks Manoj Ji

[@ashifali8367]

sir delhi me aap ka institute h kya

[@Innozant]

Yes dear

[@dipaksutradhar4404]

If want to sum atomated sapose 1st column name,I'd,payment again I'd ,name and payment and so on if I want sum those paymnent coulumn only what to do

[@Sparkle-SK]

hello sir big fan Sir ji excel meh datewise automatic sheet keise create karna hai uspe vi video banao na

[@Innozant]

Jaise ki kya chahte hain datewuse sheet create Krna.?explain kriye..bna denge video

[@himanshu6231]

how to absent employees name highlight according to date in attendance sheet

[@kittu1313]

Sir I have a doubt... How can I share an excel sheet to you to ask the doubt...

[@Innozant]

@innozantofficial telegram id

[@bhartityagi8183]

I still don't get it what is the practical implementation of vlookup with hyperlink. It makes finding more complex. Can u xplain the situation where I can apply this to make my work quicker. Bcuz going to that particular sheet and apply vlookup is more easy to me.

[@Innozant]

Why Bharti? already explained in hyperlink dynamic video as well.

[@gauravbhatia7987]

Thnq sir

[@Innozant]

Thanks Bhatia ji

[@vitthalsuryavanshi3634]

Nice sir

[@Innozant]

Thanks Amol

[@ajinkyashinde1778]

first of all happy teacher's day. iferror ke sath vlookup use karna galat hogo q k agar id ya naam dono me se ek bhi range me nahi ho to us case me wo #N/A dega wo #N/A ko nikalne ke liye aur ek iferror use karna hoga

[@Innozant]

Outer part me iferror pass kr dijiye wo apna kaam krega aur iferror with vlookup apna

[@Narendar.pathak]

Happy teachers day

[@Innozant]

Thanks Narender Ji

[@vikrambisht5321]

Nice video sir

[@Innozant]

Thanks Vikram Ji❤️

[@vikrambisht5321]

@@Innozant please share me contact no ek problem thi excel ki

[@Innozant]

@innozantofficial telegram id

[@amitrana8147]

Sir mera date text ki format mian aa raha hain usko value main kaise convert karu

[@Innozant]

Custom format se kr skte hain

[@falakshabir4258]

Sir agar sheet name main Space ho to ? For example- sheet name is City Lead Team Lead

[@Innozant]

Wildcard use kriye

[@Dalipzx]

Sir mujhe ye sikhna hai ke index sort kaise hota hai, and jo sorted data hai means filtered data ko copy paste kaise kiya jaaye ?? 2. How to copy entire data set to another sheet with formula ?? Please help

[@Dalipzx]

Please reply sir

[@vimaldewangan9309]

Dependent drop down ke sath multiply formula ka video chahiye sir please provide the video regarding mfg BOM banane ke liye

[@Innozant]

Ok..Vimal bnate hain kisi din

[@vimaldewangan9309]

@@Innozant okay sir

[@vimaldewangan9309]

@@Innozant sir please provide the video

[@vimaldewangan9309]

Sir please dependent drop down ke sath multiply formula ka video banaye

[@NaveenSingh-rt2zz]

sir how to check duplicate value in 20 digit number Cell data

[@Innozant]

Example sheet share kijiye

[@shreeram90861]

Sir ji vba kab tak start karoge app

[@Innozant]

Abhi time lgega .ek saath itne playlist nhi chal payenge..class bhi hota h mera .

[@imranali-iy5wk]

Filter across multiple worksheet pls

[@Innozant]

Ok Imran Sahab..Noted

[@sabduljabbar5026]

In excel i have 24 columns with dates and values and alternate columns. I want to extract the Maximum value and it's corresponding date in that year. And I want to extract the cell address of the value and the date .Can u please help me out of it.

[@sabduljabbar5026]

Sir please reply

[@anandsinghrawat6397]

Sir worksheet ka name change karte hai to worksheet ka title name change ho is par bhi ek video bana do please 🙏 jaise worksheet mein jan ka naam likho to jain ka ka output le aye feb ka naam likho to feb ka aye yesa kuch

[@Innozant]

Are to ye indirect use krke kar skte haina Anand ji

[@anandsinghrawat6397]

@@Innozant kaise hoga please video banaye

[@Innozant]

Ok

[@mahenderbisht2700]

Sir vba macro bhi sikha dijiye sir🙏

[@Innozant]

Macro karayenge after Power quer ,power pivot and power BI series..ek saath itne playlist sahi se chal nhi paata hai

[@prashaant6471]

Sir please jayada nhi to first 5 financial function ki hi video bana do 10 min ki hi request hai Sir

[@Innozant]

Ok.. Financial function ke aur video layenge dear

[@sathyanarayana4914]

Vlookup with is text and is number get same answer sir

[@Innozant]

Yes Sathya ..U r rightm.btata hua h doeuble vlookup mr

[@jaathdmovies876]

Sir aapki video me samjh me kam aata hai

[@Innozant]

Matlab? Kahin se bhi video dekhnege the kam aayega samjh ydi concept clear nhi hain to..aap basic excel se seekhna start kriye step by step .❤️m sure aayega samajh .koi prob to btaya kren

[@jaathdmovies876]

@@Innozant aapka samjhane ka concept samjh nahi aata hai sir