IF or VLOOKUP | If Condition vs Vlookup |Vlookup with IF Formula in Excel in Hindi
HTML-код
- Опубликовано: 12 сен 2024
- IF or Vlookup which function is best for multiple criteria.
Why there is need of Vlookup function in excel when we already have nested if even ifs function for multiple criteria or condition.
Lets try to find out with 2 interactive example explanation why we use vlookup function instead of evergreen if function in excel.
Excel Lookup Function Playlist Link- • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#excelvlookup #exceltutorial #innozant #vlookupwithiffunction
Wah sir wah👌👌👌👌🙏🙏🙏🙏🙏🙏
Kamaal hai aap
Aapke jaisa koi nhi❤️
Thanks dear❤️❤️
Jab Mark Sheet Se Result Nikalna Hota Tha 1st,2nd ya 3rd, Toh IF Condition Lagani Padti Thi, Abhi Abhi VLOOKUP Lagaya, Results 30 Seconds Se Bhi Kam Time Mai Aa Gaya.
I Always Learn Something Unique From You.
You Have Told Us What Is The Best Approach To Use All Function/Formulas.
🙏🙏🙏
We hope you will go much further, thank you very much sir
Thanks for best wishes.,M trying my best to deliver awesome content step by step for beginner to advanced learner
Sir you are explaining very well. Your class is very interesting to learn.
Thanks Manoj Ji ❤️ Happy learning
Sir Ki Line Achi thi jo pehle bohat zaruri tha ab us par taras aa raha h. Lekin sir very easy approach maza aa gaya dekh kar
Sir apki jitni video bahut hi power full h nyc sir ye video hmm logo ko bahut hi acha advance excel sikhne me help karegi nyc ❤❤sir
Thanks Gaurav Ji
Bahut badhiya explain sir
मुझे छात्रों की ग्रेडिंग करने में बहुत कठिनाई होती थी परंतु आपका ये विडियों देखकर मेरी ये समस्या छु मंतर हो गई है , आपका बहुत बहुत धन्यवाद , सरजी आप ग्रेट हो , आपको मेरा कोटि कोटि नमन ।
Thanks Vinod ji
Awesome Sir Ji
Dear sir you are very smart and your way of explaining is also very good
Thanks Nitin ji ❤️
I love your videos sir..god bless you
Excellent way of teaching.🤩
Maja aa gaya sir.. sab bolte the vlookup hard hai .
Kya kehte hain.hard hai ?
@@Innozant nahi. Abhi maja aa raha hai ..thank you
Sir yesterday se aise problem face kr raha tha If condition se but aaj mene bhi V look-up use kiya hu. Thanks Sir I like your teaching... 🙏
Thanks Jai..God bless You dear
Your teaching style is like sky way...awesome... 💫
Thanks dear for your valuable appreciation..Happy Learning
thanks a lot sir
Perfect teacher
Thank you Sir
Bahot shandar maja aa gaya 👌 😊 wah
Thanks Puran..
You are best
Thanks Ajit Ji👍❤️🙏
very great sir
So Easy method 🙏🙏
Thanks
Awesome video sir...
Thanks Ashok Ji
Sir ap nay kya concept bataya hai vlookup k baray man if ki to chutti ho gai ap yaqeen kren k mene vlookup se all students ka Grade nikal diya, very powerful information true and false.💯👍
Thanks Saqlain ..keep learning ❤️
Excellent.
Thanks
Super 👍👍❤️
Thanks dear,hv a nice day
sir apne bola tha aproximate me value data filed hamesa smallest to largest hona chahiye, nahi to anap sanap le aayega data, lekin yaha pe to dalue data sales ka kahi jyada kahi kam hai fir bhi approximate chalane ke baad sahi kaise utha liya ,
Hi Sir, I m using =VLOOKUP(D2,I5:J9,2) but it is not working for me. Basically in D2-D16 i have emp Salary and I5-I9 i have Salary slab and in J5-J9 i have Bonus Percentage
Mast sir 👌
Jab HRA Ki Value Nikalni Hoti Thi Toh Bore Ho Jaata Tha NestedIf Ka Use Karke, Now I Will Apply This.
Sir, we have used Approximate match in last example, but values were not in Ascending order...is that ok
Great sir
Thanks Deepak❤🙏
Hi sir am from Pakistan. Sir Mera aek question Hy apse. Mere pas aek data base hy jis me student name, or kuch subject hy. Sir mera condition ye he ke jis B name ko me lookup karu Hus ke wo marks "sum" ho Jo "even" hy. Please sir give me a solution ❤
excellent
Thanks Rinku.
Nice 👍🏻👍🏻👍🏻
Thanks Vijay Ji Happy learning
Wow!
thnx sir ji
Thanks Devender ji
❤
sir I have a query can you pls solve.
Great
Thanks Jaspal ji, Recomy you to learn step by step.
Sir yaha pe joh example liye , jaha par sales 10,000 hai waha 1 % nhi ye #N/A bata raha , kyu error aya
हमे 5000 line item ka GST reconciliation करने के लिए कोई एक्सेल का कोई तरीका बताये
Sie plz explain how to apply vlookup in range.. Like 0-40,40-60,60-80,... Like wise.
Using approximate match
Good
👍❤️
👏👏
❤️❤️
Unable to download any Example Practice file
Directl video link is broken ..m working on it .soon its restored
But master assignment folder lonk is working fine(all playlist assignment at ine place) you may download all and start your practice
Sir,the practice sheets of vlookup is not working . Please provide the valid link of it
Hi Chitra ,Kindly download it from second link mis assignment master ❤️
sir if me if kitni baar use kar sakte hai?
Nest up to 64 if
@@Innozant dil se thank you sir❤
Sir app se milna hain training ke liye
Visit kar lijiye institute ya whatsapp/call par query kar sakte hain dear❤️
Jab bhi hamare pass nested if ki condition aaye tab ham uski jage vlookup lagaye to jaha se bhi lookup karna hi data ko to waha ka data assending order mai hona chahiye, chahe number ho ya text
Please help
Offcourse vlookup se to nested if ka prob hi solve.
@@Innozant but mera ye puchna hai ki jab bhi ham jase lookup kar rahe hai waha ka data assending order mai hona chahiye, chahe wo number ho ya text
Mis ke liye experience mang rahe hai sir ji
Thanks Deepak Ji❤️😊
🌟🌟🌟🌟🌟 ( Tarjit Singh )
Thanks Tarjit..Ok.I thought New Subscriber that's why🙏😊.Tum to alreday welcome ho
@@Innozant m not tarjit singh, My excel is not good. So tarjit suggest me that you subscribe innozant nd maintain your excel. So truly ist vry wonderful channel for me. Thanx sir.
@@ManpreetKaur-uz8jv Ok..Manpreet,Welcome you dear,Start learning step by step(First complete Basic Excel Playlist,then sorting,Filter,What If Analysis and Vlookup in sequence)
any doubt or query message/call me will help you out.Happy Learning and share
Unable to download example workbook
Thanks Vishal for updating me,You may download it by tomorrow,May be link broken.
File uploaded,You may download it
@@Innozant Thanks for quick reply & resolution.Yes,i am able to download now!
Sir agar condition do hui to??
To bhi kya issue hai dear..nested vlookup nested if ..hai to apke paas lgane ke liye👍❤️
Sir already nested if with AND use kia hua hai uske replace mein vlookup lagana hai ek slab hai 1-50, 50-75, 75-100..........
Sir, i need one help if you share your mail id then i can mail excel with my query. Thanks
@innozantofficial telegram id
बहुत कंफ्यूज करते हो यार
Kyu Confuse ho gye Sunil Ji..Ye decision making hai ki kya behtar Hoga apply karna dear🙂👍🙏♥️
@@Innozant सर थोड़ा डिटेल में explain किया कीजिये सभी चीजो को।।
बहुत से शव्द आप ऐसे बोल जाते हो जो बिगिनर को समझ ही नही आता।
अगर आपका कोई कोर्स है जो डिटेल में छोटी सी छोटी चीजो को एक्सेल फॉर्मूला को explain करे तो प्ल्ज़ बताये
Sunil Ji aap random video Dekh Rahe Hain kahin Kahi se isliye aisa lag raha hai ki choti choti cheezo pe dhyan nhi Diya Gaya hai.. Dear pehle Basic Excel Seekhiye.
Apni Learning Basic Excel Playlist-1st video se kijiye ,jab basic khatam ho Jaye phir advance sortin,filter,what If Analysis Uske baad vlookup video dekhiye..Aap seedhe vlookup ke video Dekh Rahe Hain tbhi aisa lag raha dear.
Complete video tutorial hai Step by Step
Thank you sir