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.c...
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

[@ManishVerma-gg8xl]

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

[@Innozant]

Thanks Manish Ji♥️👍

[@khaledmorshed1932]

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

[@mosadiq123]

Sir, you are the best teacher in excel

[@Innozant]

Thanks ❤️🙏

[@VimalKumar-ih6ik]

Your style of teaching gives us knowledge along with motivation.

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

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

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

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

[@vishalbhati912]

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

[@yogeshmishra7780]

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

[@Innozant]

Thanks.keep learning

[@narottammanihal8463]

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

[@Innozant]

Thanks Narottam ji❤️❤️❤️

[@saddamalam478]

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

[@Innozant]

Thanks dear.Happy learning ❤️

[@cartoonloversop6019]

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

[@Innozant]

Thanks dear..God bless You ❤️

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

[@AbhishekMishra-lh3jw]

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

[@Innozant]

❤️👍👍

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

[@pravinkumbhare1750]

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

[@Innozant]

Thanks dear

[@Innozant]

Thanks dear

[@sohrabali6080]

Unbelievable vlookup policy. Great. Thanks 👍

[@Innozant]

Thanks dear

[@koushikmaity3954]

Your teaching technique is really good.🙏🙏🙏

[@Innozant]

Thanks Koshik ji..Happy learning dear

[@dileepmaurya5632]

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

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

[@cricketgermination463]

Sir your every video is much much better than others

[@Innozant]

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

[@pt_shivam]

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

[@Innozant]

Thanks .keep learning

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

[@atulshukal4072]

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

[@Innozant]

धन्यवाद सर जी

[@princejoshaf336]

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

[@uniquemobiletipstricks7714]

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

[@shakeelahamad4920]

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

[@Innozant]

Thanks Shakeel sahab..Happy learning ❤️

[@jaishrisaxena1083]

ultimate approach of teaching !

[@Innozant]

Thank You Jaishri for wonderful feedback.Hope it helps

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

[@ahmedshahzad9402]

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

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

[@naseemakbar6962]

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

[@Innozant]

Thanks Naseem

[@arunkumarsinghark3024]

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

[@satishmestry5687]

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

[@Innozant]

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

[@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 🙏❤️

[@brijeshshah574]

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

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

[@rohinikrishna3601]

Nicely explained, learning from you, thanks a ton.

[@Innozant]

Thanks Rohini.Happy Learning ❤️

[@VinodThakur-v2b]

फँटॅस्टिक मास्टर 🌹

[@heeralalkumawat2132]

Sir You are great in Excel

[@Innozant]

Thanks Heera ..Happy Learning ❤️

[@heeralalkumawat2132]

​Welcome

[@truepearl9334]

You are great sir.

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

[@K_K_Panda]

Very nice topic Thank you Bhai..

[@Innozant]

Thanks dear

[@techniqueworld1202]

thanks , it help me a lot

[@swapnilpawar708]

Awesome bro perfect iferror use

[@Innozant]

Thanks dear

[@vikasgawaria5330]

Logical video sir thankyou so much

[@Innozant]

Thanks

[@shahzadsami5613]

Beautiful Explanation, Thanks

[@Innozant]

Thanks Sami sahab

[@Veenu-yi7pc]

Excellent learning

[@Innozant]

Thanks Suresh ji

[@RahulGautam-rb8ij]

Bht khoob 👍👍👍👍

[@dillipkumarbehera9060]

Excellent sir

[@Washaista]

Wow magical formula 👍👍👍

[@Innozant]

Thanks ❤️🙏

[@theroyalmaratha96k]

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

[@straightpathnetworks1658]

no one teaches excel better than innozant.

[@Innozant]

Thanks dear for your valuable appreciation ♥️

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

[@kinghundred]

very great sir

[@NAJAKAT26]

Nicely explained.. Thumbs up and clapping

[@Innozant]

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

[@Pooja-bd7zm]

Very great sir👏👏

[@Innozant]

Thanks Pooja..Happy learning ❤️🙏

[@karansingh-pq5pn]

Grreat job. Thank you.

[@Innozant]

❤️❤️❤️😊

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

[@vijaysahal4556]

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

[@Innozant]

Thanks Vijay ji❤🙏

[@BalvirSingh-qs9kz]

Very nice .

[@VikramKumar-du2mw]

Awesome trick 👌👌

[@goodness377]

Guruji very creative,

[@Innozant]

Thanks Sinha sahab

[@rakeshkumarbarman5232]

Mazaa agaya sir...

[@saeedakhtarkhan5481]

Very Good

[@meditationmusic6482]

Sir.ji sooooo liked this video 📷

[@Innozant]

Thanks Sanoj...

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

[@muhammadsadiq8885]

Very nice

[@BalvirSingh-qs9kz]

Sir, very nice.

[@Innozant]

Thanks Balvir ji🙏❤️

[@harishbhati3651]

Big fan ho gya sir apka

[@Innozant]

Thanks ❤️🙏 Harish ji

[@udaybhangupta2026]

Amazing sir Thank you so much

[@Innozant]

Thanks Uday Ji🙂🙏❤️

[@pankubisht3495]

U are great sir

[@Innozant]

Thanks Pankaj Ji❤️🙏

[@rkldelhidepot4788]

I love sir ❣️ tusi great ho

[@Innozant]

Thanks ..Happy learning ❤️

[@mariantonys]

youbare genious

[@riteshtiwari9382]

Good afternoon sir

[@techgurusatveer3364]

Hello sir You r amazing but I have a challenge for you. I want to put multiple values in one cells using formulas . Like if there is uk and in front of uk there are several items have been give and I want to bring all those values in one cell then how I can do this using formulas plz let me know.

[@Innozant]

Satveer Ji...Aap yadi Query kiye hote to main jaroor apke Question man answer comment me hi de deta ..Lekin( I have a challenge for You) Ka matlab Thora samajh nhi Aaya dear... Technical discussion Karna hai to aaiye Live session me join kariye Zoom ke through phir karte Hain discuss detail me.🙏❤️❤️

[@techgurusatveer3364]

Sir challenge in the sense I believe that you can do this

[@someonefrom2002]

@@Innozant Great answer sir 👌😆

[@madhavam718]

Super sir

[@Veenu-yi7pc]

Excellent

[@Innozant]

Thanks

[@sethushankaranmadhavanmadh6712]

Superb betaaa...

[@Innozant]

❤️❤️🙏

[@mukeshkumar-cv7vz]

How to use vlookup if some cell has data..mean jin cells me data hai wo chood de aur jo cell empty hai unme data vlookup se aa jaye..ye kaise hoga

[@YRS13]

Thnx

[@gauravbhatia7987]

Thnq sir

[@arunkumarsinghark3024]

Sir, मेरे पास same ऐसे ही problem आते हैं ऑफिस में excel sheet पर काम करते समय, उसमे six digit ka number दिया गया होता है, फिर नीचे पांच दस cell blank रहता है और फिर उसके नीचे six digit का दूसरा number दिया गया रहता है और यही प्रक्रिया बारंबार लगभग हज़ारों लाइन पर दोहराई गई होती है, और हमे vlookup लगाकर उस six digit को किसी other sheet पर दिए गए same data range से match कराकर check करना होता है और उसमे कुछ और numbers dot separator के साथ add करके एक complete format बनाना होता है जैसा हमारे organization को जरूरत होती है, तो इसके लिए हमें, empty cell को पहले fill out करके उसके बाद formula लगाना पड़ता है, please please please sir, इसको जैसे ये formula बता रहे हैं ठीक उसी तरह short मे solve करने का तरीका सिखाए please, आप कहे तो वो data base आपको दिखा सकता हूँ जिससे query आप आसानी से समझ सके l कृपया मार्गदर्शन करे l 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍

[@round2death645]

Pls make a video on if+left+vlookup function

[@Innozant]

Already hai interview cracker series me..ok..seprate bhi example bna denge dear

[@samareshb6596]

I have been seeing your videos, this one is unique, if A2, A3 is blank & we have A4 = UK, then how to solve the problem

[@Innozant]

Thanks Samaresh Ji🙏❤️👍if blank then we need to pass the text by own .

[@vikrambisht5321]

Very nice sir

[@Innozant]

Thanks Vikram Ji❤️

[@vikrambisht5321]

@@Innozant welcome sir

[@rajeshyelle3815]

If Idint wants an upper cell result, I want a blank cell. Then how to do it? Please help me.

[@knockenter4483]

Can I share my sheet for help

[@battlefansshorts8941]

Kya magic hai sir maja aa gya

[@Innozant]

Thanks Ravi Ji..God bless you dear

[@akak3585]

Nice sirG

[@subirdas253]

Really best

[@Innozant]

Thanks Subir

[@tapasmukhopadhyay721]

Nice useful

[@Innozant]

Thanks Tapas..

[@santoshkumar-sd6un]

Sir please help me where if column1 is blank I should get value from column2, if column2 is also blank I should get value from column3. Is it possible. Please give me solution.

[@perfectlover9918]

Thank uhh sir

[@Innozant]

thanks dear ❤

[@sarvodayaconventvidisha1757]

Super

[@souravamat1904]

sir vlookup main value agar formula base hey to kese kare

[@pulakgoswami6697]

Great