Vlookup an Empty Cell | If Lookup Cell is BLANK then...Vlookup MagicTrick in hindi
HTML-код
- Опубликовано: 1 окт 2024
- 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
Excellent! I'm an English speaker and I still understood everything by your perfect illustrations. Great job!
Thanks Metta❤️❤️
Sir 60 types farmula ka pdf dikhaiye
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
Thanks Shubhi..God bless you .Happy learning ❤🙏
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..
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 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍
Thank you very much 🙏 sir for your support 🎉we really satisfied your teaching ❤ Love you so much sir
सर
खेतका हिसाब कैसे करें ।
जैसा कि
1 बिघा 6 कठ्ठा 15 धुर और 1 बिघा 16 कठ्ठा 10 धुर का जोड कैसे करें excel मे ।
Aap sheet banake mujhe share kijiye
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.
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😊
your students get deafferents knowledge from others, thank you guru Jee
You are the best teacher 🦂🦂🦂परफॉरमेंस
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
If Idint wants an upper cell result, I want a blank cell. Then how to do it? Please help me.
If look value of data is blank then it shows zero ,how to get blank instead of zero
superb. ap ne excel ko fool bna dia....excellent:
Vlookup par attendance or payroll kaisey banta h
sir vlookup main value agar formula base hey to kese kare
Me bhai jag gaya 😂
Bahut bahut dhanyvad Sir🙌🙏😇
sir i wish if were kiss you , love from Bangladesh
हमे same column मे ही data चाहिए l
VLOOKUP का आपरेशन बहुत बड़ीया गुरुजी बहुत सारा ज्ञान और सोचने की पावर बड़ जाती है आपकी class join करके ।
बहुत बहुत आभार आपका आदरणीय 🙏🙏🙏
Thanks Manish Ji♥️👍
The skill of your teaching is amazing sir... ❤❤🙏🙏 thank you so much sir for teaching us... 🙏🙏
Thanks .keep learning
Agar cell blank Lani ho to
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....❤
Thanks Jha.. Really meay a lot
Maja aa gaya bhai bhut hi intrusting video bnate hoo.... Matlab 1year ka course sirf kuch video me ❤️❤️❤️😍😍😍
❤️👍👍
मैने बहुत से vlookup के वीडियो देखा
मगर आप के जैसा नही
Best
Thanks Naseem
sir agr har code ke state wale column ki first cell blank hai aur niche fill hai to mujhe uper wale cell main jo niche cell mai value hai wo lani hai to kese krege.. please btayega..meri report tally se export ki huye hai or Google sheet use krta hu
Bwttwe ek baar aap apna workshewt dikha payen to help kr skte h easily apki
Can I share my sheet for help
Sir
You are great in Excel
Thanks Heera ..Happy Learning ❤️
Welcome
Sir before even before watching your I hit the like button cause I know your all videos are valuable
Thanks Saqib sahab.. Really means a lot that me dear
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 👌 👌👌
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.
@@Innozant Yes Sir definitely 🙂
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.
Thanks.Keep Growing
Sir, you are the best teacher in excel
Thanks ❤️🙏
Bht khoob 👍👍👍👍
Aap pdf dikhsiye
Sir apki video clear ni dhikayi deti jisse hum pratice kr ske kya formula lgaya h....
Laptop par dekhiye videos..ye start ke video hain dear..😊
Super
Gajab ka chaliki dikhai apne kayal hogaya sir aapka real bhut maza aarha sikhne mein mind blowing....
Thanks dear.Happy learning ❤️
thanks , it help me a lot
Mazaa agaya sir...
youbare genious
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.
Good afternoon sir
You are great sir.
अति सुंदर सर जी धन्यवाद्, आप excel के जादूगर है, 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Sir mera aap Sai ek question hi ki mera logic clear nhi ho raha hi ore main interview per jata hu but clear nhi ho raha hi please help me sir
Means aapke concept clear nahi hain abhi.Focus hoke kriye practice
Bahot hi badhiya aur important Topic aapne sikhaya hai Sir... Dhanyawad.. 🙏🙏🙏🙏🙏
Thanks dear
Thanks dear
Excellent sir
Logical video sir thankyou so much
Thanks
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 🙏
गजब sir❤।। आप genius है
What if the value is blank? How do we get a desired message?
Didn't get you.. kindly explain your query.
Sir your every video is much much better than others
Thanks dear...Happy learning..God bless you 🙏❤️
Pls make a video on if+left+vlookup function
Already hai interview cracker series me..ok..seprate bhi example bna denge dear
very great sir
mazaa aa gaya sir.
aise hi videos banate rahiye.
thank you sir.
Thanks dear..God bless you..🙏❤️
Nice sirG
Very nice
Aap ek bahut hi mazedar insaan aur teacher hain 😊 Namaskar aur Naman
Thanks.keep learning
Very nice .
Your style of teaching gives us knowledge along with motivation.
Very Good
Excellent. Bahot badiya. Me toh ise goto special se karta. But aapne bahot badiya dimag lagaya
Very nice topic
Thank you Bhai..
Thanks dear
lajwab level ha sir ap ka from gujranwala pakistan
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 🙏❤️
Super sir
Thnq sir
very nice
bahot he umda trika hai sir aaap ka kiya baat krun aaap ki main tu dua hai sil say aaap k liye
Thanks...❤️❤️
Great
Dear Sir, Meri Please Ek Help krein please.
Meine ek sheet mein Formula Lagaya hai IF ISBLANK Ka but jab mein cell ko drop down kar rha hun to value repeat ho rahi hai tau mujhe usme ek or kya add karna hoga jisse value repeat na hoo.. please help baki agar aap kahein to sheet apko kaise share karu please help sir
countif use kariye uske through occurrence nikal lijiye
e.g countif($A$1:A1,A1)=1
@@Innozant Thanku So kuchh sir.🙏
SIR AAP NE KYA PRESS KIYA JIS SE PATA CHALA K YE FORMULA SE YE RESULT AAAY
F9 se evaluate karte hain dear
Thnx
Sir mai practice karata hu o sheet aapko kaise dikhau ..
mail kar diya kijiye video ke about section me msil id h
Sir mera aaj interview thaa aur vlookup ka question aaya tha mera na error aa gaya just becoz woh lookup right to left karna tha
Gad bad ho gayi aaj toh
Are..Vlookup ke saath choose chalate na..seekhaya hai na aapko❤️❤️
Haan sir main phir se practice karronga. Aur interview aate rahenge but i got learning from that one. 😀😀
🙏🏼🙏🏼👌
where is practics sheet link
Find it in video description..master assignment folder
बडी उम्मीद के साथ कमाल कर दिया साहेब
धन्यवाद सर जी
👍👍👍👍
Grreat job. Thank you.
❤️❤️❤️😊
Wow magical formula 👍👍👍
Thanks ❤️🙏
how do we get excel file for practice
Dear Partho Kindly find Practice file (All playlist at single place link) from video description (available in every video description).. Thanks for being part of Innozant family. Happy Learning dear ❤️❤️❤️🙏🙏
😃
Awesome bro perfect iferror use
Thanks dear
Sir.ji sooooo liked this video 📷
Thanks Sanoj...
Hi sir..I need your help..mein filter cells me vlookup lagti hun to jo mera hide data hota h uspe sey data remove hoke NA aa jata hai..please help..
kuch to galti kar rhe hain Riya..@innozantofficial telegram id par send kijiye apna sheet with query explanation
Ok
Actually ye pehle nh ho rha tha jab sey mene excel 2007 liya hai tab sey ye problem face kar rhi hun me or same problem mujhe filter ops use karney me bhi aati hai..
can't stop myself to provide comments below...Truly Excellent...Keep going, Mr. Trainer...
Thanks Priya.. Really means a lot to me.👍❤️
Keep Learning..Keep Exploring..
In sequence..Step by step
Kya magic hai sir maja aa gya
Thanks Ravi Ji..God bless you dear
I love sir ❣️ tusi great ho
Thanks ..Happy learning ❤️
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.
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.
Sir you are genius, your questions are very logical. Keep it up 🙏🙏🙏🙏
Vlookup ignore duplicates. If in lookup value range there r duplicates then how to get result using vlookup?
Duplicate vlookuo using countif first find the unique occurance then go ahead with lookup..soon you may able to watch this video under playlist excel maharaj
Guruji very creative,
Thanks Sinha sahab
Very Nice Sir. Your way of explanation is awesome & amazing. Keep it up. GOD bless you
Thanks Shakeel sahab..Happy learning ❤️
Very nice video
Thanks Dear,Hope you like the video and learn from there to enhance your skills ,You may contact me on -7065069985
Excellent learning
Thanks Suresh ji
Sir aap telegram par kis Naam se hain
Innozant
Join Innozant telegram channel
t.me/innozant
Find me on Telegram
@Innozantofficial
Big fan ho gya sir apka
Thanks ❤️🙏 Harish ji
Very great sir👏👏
Thanks Pooja..Happy learning ❤️🙏
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
Thanks Samaresh Ji🙏❤️👍if blank then we need to pass the text by own .
Sir i am learning new things in Vlookup , Feeling nic that getting new concepts to learn ,thank you so much sir
Thanks Pawan Ji ❤️