Vlookup an Empty Cell | If Lookup Cell is BLANK then...Vlookup MagicTrick in hindi

Learn how to use vlookup an Empty Cell
1. When cell is empty in VLOOKUP table it returns a zero. See IFERROR formula to return text instead.
2. When data items that you are looking for is not in VLOOKUP table it returns an #N/A error.See use of Iferror function and ifna function to get the solution.
3. Learn how to fill in the empty cells in a VLOOKUP table
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookup#vlookuponemptycell #Innozant #exceltutorial

[@shubhiagarwal7327]

best best best teacher for excel and sheet in india.....20 days se pareshan tha iss problem ko leker ... aapki video ne 2 min me solve kar dia

[@Innozant]

Thanks Shubhi..God bless you .Happy learning ❤🙏

[@mettamia2008]

Excellent! I'm an English speaker and I still understood everything by your perfect illustrations. Great job!

[@Innozant]

Thanks Metta❤️❤️

[@rasbihari1909]

Sir 60 types farmula ka pdf dikhaiye

[@vishalbhati912]

Excellent. Bahot badiya. Me toh ise goto special se karta. But aapne bahot badiya dimag lagaya

[@ManishVerma-gg8xl]

VLOOKUP का आपरेशन बहुत बड़ीया गुरुजी बहुत सारा ज्ञान और सोचने की पावर बड़ जाती है आपकी class join करके ।
बहुत बहुत आभार आपका आदरणीय 🙏🙏🙏

[@Innozant]

Thanks Manish Ji♥️👍

[@khaledmorshed1932]

your students get deafferents knowledge from others, thank you guru Jee

[@dileepmaurya5632]

Sir you are genius, your questions are very logical. Keep it up 🙏🙏🙏🙏

[@RahulGautam-rb8ij]

Bht khoob 👍👍👍👍

[@sohrabali6080]

Unbelievable vlookup policy. Great. Thanks 👍

[@Innozant]

Thanks dear

[@saddamalam478]

Gajab ka chaliki dikhai apne kayal hogaya sir aapka real bhut maza aarha sikhne mein mind blowing....

[@Innozant]

Thanks dear.Happy learning ❤️

[@theroyalmaratha96k]

गजब sir❤।। आप genius है

[@VimalKumar-ih6ik]

Your style of teaching gives us knowledge along with motivation.

[@truepearl9334]

You are great sir.

[@narottammanihal8463]

Excellent Sir, Apne toh sach me vlookup ka operation karna sikha diya. Thank you so much.

[@Innozant]

Thanks Narottam ji❤️❤️❤️

[@atulshukal4072]

बडी उम्मीद के साथ कमाल कर दिया साहेब

[@Innozant]

धन्यवाद सर जी

[@AbhishekMishra-lh3jw]

Maja aa gaya bhai bhut hi intrusting video bnate hoo.... Matlab 1year ka course sirf kuch video me ❤️❤️❤️😍😍😍

[@Innozant]

❤️👍👍

[@uniquemobiletipstricks7714]

You are the best teacher 🦂🦂🦂परफॉरमेंस

[@techniqueworld1202]

thanks , it help me a lot

[@Balaji-pq6cz]

Excellent Sir😅 Unique formula ka istemal sirf aap he kar sakte ho... Maine aap se he sikhkar Job paya hai aur selection bhi hua as a MIS Executive 😊 Thank you so much sir.

[@Innozant]

Thanks.Keep Growing

[@rakeshkumarbarman5232]

Mazaa agaya sir...

[@arunkumarsinghark3024]

अति सुंदर सर जी धन्यवाद्, आप excel के जादूगर है, 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@nageshkaria6190]

your teaching methods is very easy and effective. thank you so much for that. I learn so much things from your videos and still learning new new things.
Dand vat pranam 🙏

[@ahmedshahzad9402]

superb. ap ne excel ko fool bna dia....excellent:

[@VikramKumar-du2mw]

Awesome trick 👌👌

[@cartoonloversop6019]

सर , सच मे हि आपने Vlookup का ऑपरेशन कर दिया मजा आ गया Interesting

[@Innozant]

Thanks dear..God bless You ❤️

[@brijeshshah574]

Me bhai jag gaya 😂
Bahut bahut dhanyvad Sir🙌🙏😇

[@satishmestry5687]

mazaa aa gaya sir.
aise hi videos banate rahiye.
thank you sir.

[@Innozant]

Thanks dear..God bless you..🙏❤️

[@dillipkumarbehera9060]

Excellent sir

[@AlimKhan-bl5sh]

Sir ek baat bolna chahoonga... Wah re wah londe maan gaye😂❤❤.. Pehle me ek channel h computer gyan usko follow karta tha.. Jab se apkii video dekhii unko bhool gaya😊

[@shahzadsami5613]

Beautiful Explanation, Thanks

[@Innozant]

Thanks Sami sahab

[@jaishrisaxena1083]

ultimate approach of teaching !

[@Innozant]

Thank You Jaishri for wonderful feedback.Hope it helps

[@kinghundred]

very great sir

[@princejoshaf336]

Thank you very much 🙏 sir for your support 🎉we really satisfied your teaching ❤ Love you so much sir

[@vikasgawaria5330]

Logical video sir thankyou so much

[@Innozant]

Thanks

[@yogeshmishra7780]

Aap ek bahut hi mazedar insaan aur teacher hain 😊 Namaskar aur Naman

[@Innozant]

Thanks.keep learning

[@rohinikrishna3601]

Nicely explained, learning from you, thanks a ton.

[@Innozant]

Thanks Rohini.Happy Learning ❤️

[@naseemakbar6962]

मैने बहुत से vlookup के वीडियो देखा
मगर आप के जैसा नही
Best

[@Innozant]

Thanks Naseem

[@PriyaRanjanNayak-hg4bx]

can't stop myself to provide comments below...Truly Excellent...Keep going, Mr. Trainer...

[@Innozant]

Thanks Priya.. Really means a lot to me.👍❤️
Keep Learning..Keep Exploring..
In sequence..Step by step

[@BalvirSingh-qs9kz]

Very nice .

[@K_K_Panda]

Very nice topic
Thank you Bhai..

[@Innozant]

Thanks dear

[@karansingh-pq5pn]

Grreat job. Thank you.

[@Innozant]

❤️❤️❤️😊

[@shaileshjha6623]

Till yet although I was using and/or with if function frequently...but the way you explained the parenthesis breakup gives clarity at other level....❤

[@Innozant]

Thanks Jha.. Really meay a lot

[@swapnilpawar708]

Awesome bro perfect iferror use

[@Innozant]

Thanks dear

[@MEGAMINDLIVE]

oh no!!!!! same question is in my two days ago data analyst assessment. my bad luck i didn't see this videos before my assessment. but now i know very well to how to do this type of tasks. Thanks Sir.

[@Innozant]

Ohh..Mahesh ji..No issue..Next time.Recommend you to start your learning journey from Playlist Bashx Excel then proceed with advanced excel followed by Interview cracker.

[@koushikmaity3954]

Your teaching technique is really good.🙏🙏🙏

[@Innozant]

Thanks Koshik ji..Happy learning dear

[@muhammadbilal1947]

lajwab level ha sir ap ka from gujranwala pakistan

[@Innozant]

Thanks Bilal Sahab itne valuable aur pyare comment Ke liye dear🙏❤️
Oh Aap Pakistan se hain..Grear.. Thanks.Happy learning..Umeed karta hu apke life me ye videos value add kar rahe honge 🙏❤️

[@saeedakhtarkhan5481]

Very Good

[@mosadiq123]

Sir, you are the best teacher in excel

[@Innozant]

Thanks ❤️🙏

[@Washaista]

Wow magical formula 👍👍👍

[@Innozant]

Thanks ❤️🙏

[@NAJAKAT26]

Nicely explained.. Thumbs up and clapping

[@Innozant]

Thanks Najakat Ali Sahab.We welcome you to experience the taste of success.🙏♥️

[@cricketgermination463]

Sir your every video is much much better than others

[@Innozant]

Thanks dear...Happy learning..God bless you 🙏❤️

[@sanjaygupta-qj3ym]

Sir apka sikhane ka tarik awesome h, apki vlookup series bahot hi badiya or interesting h

[@Innozant]

Really means a lot to me dear

[@muhammadsadiq8885]

Very nice

[@pravinkumbhare1750]

Bahot hi badhiya aur important Topic aapne sikhaya hai Sir... Dhanyawad.. 🙏🙏🙏🙏🙏

[@Innozant]

Thanks dear

[@Innozant]

Thanks dear

[@Pooja-bd7zm]

Very great sir👏👏

[@Innozant]

Thanks Pooja..Happy learning ❤️🙏

[@umeshautade8458]

This same question was asked me in one interview. At that time I'm unable to answer but now you clearly explained and I will definitely give answer next time 🙂
Thank you Sir 👌 👌👌

[@Innozant]

Thanks Umesh,M really happy as you said these videos add values in your life.God bless you dear.Happy Learning and try to enhance your skills on regular basis.

[@umeshautade8458]

@@Innozant Yes Sir definitely 🙂

[@rhashmi1]

very nice

[@Veenu-yi7pc]

Excellent learning

[@Innozant]

Thanks Suresh ji

[@shakeelahamad4920]

Very Nice Sir. Your way of explanation is awesome & amazing. Keep it up. GOD bless you

[@Innozant]

Thanks Shakeel sahab..Happy learning ❤️

[@YRS13]

Thnx

[@gauravbhatia7987]

Thnq sir

[@pankubisht3495]

U are great sir

[@Innozant]

Thanks Pankaj Ji❤️🙏

[@mariantonys]

youbare genious

[@harishbhati3651]

Big fan ho gya sir apka

[@Innozant]

Thanks ❤️🙏 Harish ji

[@udaybhangupta2026]

Amazing sir Thank you so much

[@Innozant]

Thanks Uday Ji🙂🙏❤️

[@madhavam718]

Super sir

[@pulakgoswami6697]

Great

[@saqibaslam2431]

Sir before even before watching your I hit the like button cause I know your all videos are valuable

[@Innozant]

Thanks Saqib sahab.. Really means a lot that me dear

[@BalvirSingh-qs9kz]

Sir, very nice.

[@Innozant]

Thanks Balvir ji🙏❤️

[@akak3585]

Nice sirG

[@goodness377]

Guruji very creative,

[@Innozant]

Thanks Sinha sahab

[@subirdas253]

Really best

[@Innozant]

Thanks Subir

[@pawanwakale8801]

Sir i am learning new things in Vlookup , Feeling nic that getting new concepts to learn ,thank you so much sir

[@Innozant]

Thanks Pawan Ji ❤️

[@rkldelhidepot4788]

I love sir ❣️ tusi great ho

[@Innozant]

Thanks ..Happy learning ❤️

[@vijaysahal4556]

you are amazing sir 👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay ji❤🙏

[@kalwantsingh4997]

Amazing.

[@Innozant]

Thanks Kalwant sahab❤️🙏

[@perfectlover9918]

Thank uhh sir

[@Innozant]

thanks dear ❤

[@Veenu-yi7pc]

Excellent

[@Innozant]

Thanks

[@sethushankaranmadhavanmadh6712]

Superb betaaa...

[@Innozant]

❤️❤️🙏

[@meditationmusic6482]

Sir.ji sooooo liked this video 📷

[@Innozant]

Thanks Sanoj...

[@sarvodayaconventvidisha1757]

Super

[@tapasmukhopadhyay721]

Nice useful

[@Innozant]

Thanks Tapas..

[@tarun_k_shorts]

wonderful 🔥🔥🔥

[@Innozant]

Thanks Tarun ❤️

[@pt_shivam]

The skill of your teaching is amazing sir... ❤❤🙏🙏 thank you so much sir for teaching us... 🙏🙏

[@Innozant]

Thanks .keep learning

[@battlefansshorts8941]

Kya magic hai sir maja aa gya

[@Innozant]

Thanks Ravi Ji..God bless you dear

[@sandeepgusain2154]

gazab...

[@Innozant]

Thanks dear❤️

[@chandra2047]

It's amazing

[@Innozant]

🙏❤️👍

[@yurialexkov2797]

Superb

[@Innozant]

🙏❤️

[@RudraStarP]

Very nice video

[@Innozant]

Thanks Dear,Hope you like the video and learn from there to enhance your skills ,You may contact me on -7065069985

[@tusharpawar3557]

Nice

[@Innozant]

thanks

[@heeralalkumawat2132]

Sir
You are great in Excel

[@Innozant]

Thanks Heera ..Happy Learning ❤️

[@heeralalkumawat2132]

​Welcome

[@satishsirsikar7104]

Your teaching methods is very easy and effective. thank you so much for that. I have a problem with vlookup - column A has similar text or number, how can I get vlookup result on the basis of column A to other columns data. Please sir.

[@vikrambisht5321]

Very nice sir

[@Innozant]

Thanks Vikram Ji❤️

[@vikrambisht5321]

@@Innozant welcome sir

[@riteshtiwari9382]

Good afternoon sir

[@sawaimalhi8439]

bahot he umda trika hai sir aaap ka kiya baat krun aaap ki main tu dua hai sil say aaap k liye

[@Innozant]

Thanks...❤️❤️

[@mohitchauhan7808]

👍👍👍👍

[@deepakchauhan4974]

great sir ji, Can we expect VBA later on sir, Because I am damn sure the way you makes you understand can no one give us .

[@Innozant]

Yes..Will surely make Vba and Sql series dear

[@AlimKhan-bl5sh]

Sir plzz ek video account k upar bana dijiye.. Accountant banne k liye.. Kya kya command sikhna zaroorii hota h.. Kitne Or konse formule use hote h.. Plzzz sir ek video bana dijiye..

[@Veenu-yi7pc]

I am a senior citizen but I take interest in your class for learning excel .Give some tutorials on vba

[@Innozant]

Thanks Sir for your valuable appreciation.Will upload VBA series after Power (Power query,Power Pivot,Power BI) series.

[@vsrjob]

🙏🏼🙏🏼👌

[@straightpathnetworks1658]

no one teaches excel better than innozant.

[@Innozant]

Thanks dear for your valuable appreciation ♥️