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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

Sir your every video is much much better than others

Sir, you are the best teacher in excel

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

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😊

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

Your style of teaching gives us knowledge along with motivation.

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

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 🙏

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.

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

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

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

Unbelievable vlookup policy. Great. Thanks 👍

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

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 👌 👌👌

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

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

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

lajwab level ha sir ap ka from gujranwala pakistan

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

Very nice topic Thank you Bhai..

Your teaching technique is really good.🙏🙏🙏

Logical video sir thankyou so much

You are great sir.

Awesome bro perfect iferror use

ultimate approach of teaching !

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

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

Sir You are great in Excel

thanks , it help me a lot

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

Bht khoob 👍👍👍👍

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

Mazaa agaya sir...

Wow magical formula 👍👍👍

Excellent sir

Grreat job. Thank you.

Excellent learning

very great sir

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

Nicely explained, learning from you, thanks a ton.

Very great sir👏👏

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.

Big fan ho gya sir apka

Very nice .

Guruji very creative,

Beautiful Explanation, Thanks

Nicely explained.. Thumbs up and clapping

U are great sir

I love sir ❣️ tusi great ho

Sir, very nice.

Very Good

Sir.ji sooooo liked this video 📷

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

Very nice

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

Awesome trick 👌👌

no one teaches excel better than innozant.

youbare genious

Superb betaaa...

Kya magic hai sir maja aa gya

Super sir

Really best

Excellent

Amazing sir Thank you so much

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

Thank uhh sir

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

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 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍

Nice sirG

Thnq sir

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

Very nice sir

Nice useful

Amazing.

Great

Thnx

sir vlookup main value agar formula base hey to kese kare

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

Good afternoon sir

Superb

Super

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 .

gazab...

Pls make a video on if+left+vlookup function

Can I share my sheet for help