VLOOKUP Formula with Multiple Criteria in Excel in Hindi | Vlookup multiple criteria

Learn how to use the Vlookup formula with multiple criteria.
Most of us know, how to use the simple vlookup formula in excel. But we face challenges if we get duplicate values in the column or if multiple criteria come in the data. 🔥🔥🔥🔥
What you will learn in this video:
✔️ How to use the vlookup formula in excel
✔️ How to use the vlookup with multiple criteria
✔️ How to use the vlookup formula and choose the formula together
▼ DOWNLOAD EXCEL FILE - mdatafinnovati...
----------------◀◀◀ KZbin Playlist ▶▶▶------------
ADVANCED EXCEL LATEST VIDEOS - bit.ly/3tRuOJ5
EXCEL FORMULAS & FUNCTIONS - bit.ly/33lp6UZ
USE MULTIPLE FORMULAS TOGETHER - bit.ly/350p0Cy
EXCEL SHORTS | EXCEL TIPS & TRICKS - bit.ly/3nx2ojd
EXCEL TOOLS - bit.ly/350Dp1z
----------------▪▪◾◼◼Social Media ◼◼◾▪▪------------
WEBSITE LINK - www.mdatafinno...
KZbin CHANNEL - www.youtube.co...
FACEBOOK PAGE - / mdatafinnovaticsofficial
TWITTER PAGE - / mfinnovatics
INSTAGRAM PAGE - / mdatafinnovatics
COMPANY LINKEDIN PAGE - / mdatafinnovatics
QUORA - www.quora.com/...
----------------------⬅◀◼Blogs◼▶➡----------------------
How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - www.mdatafinno...
---------------✉️✉️✉️Contact Us✉️✉️✉️--------------
EMAIL ADDRESS: [e-mail]
✔️ vlookup multiple values
✔️ vlookup with multiple criteria
✔️ index match multiple criteria
✔️ vlookup for multiple lookup values
✔️ vlookup multiple criteria
✔️ lookup multiple criteria
✔️ Excel VLOOKUP Function with Multiple Criteria
✔️ excel vlookup multiple criteria
✔️ vlookup formula with multiple criteria
✔️ multiple values vlookup excel
✔️ vlookup multiple cells in excel
✔️ vlookup for multiple columns
#mdatafinnovatics #vlookupformula #vlookupmultiplevalues #excelinhindi

[@kamleshvaghela6211]

super sir ji

[@MDataFinnovatics]

Thank you Kamlesh!

[@umashankarchoudhary7251]

Thanks sir... great

[@MDataFinnovatics]

Thank Uma Shankar Choudhary.

[@Natural_edit_919]

Bhai Aaj apka first video dekha apne Dil Jeet liya ab main kishi or ka video nahi dekhate hai 🎉🎉🎉 I like your videos

[@jojinfoworld]

Like bhi kia Subscribe bhi kia or apka Dil rakhne ke liye Comment bhi kar lia ❤ I am from Pakistan Thanks

[@MDataFinnovatics]

Thank you Joj video ko pasand karne ke liye!

[@foodparadise7272]

Sir you are doing great and you have great knowledge 👌i wish you make more videos ahead🙏

[@MDataFinnovatics]

Sure Food Paradise. Thanks for liking our videos. Don't forget to share and subscribe the channel!!

[@foodparadise7272]

@@MDataFinnovatics Definitely Sir

[@kadarmumbaikar]

Skillful videos k liye bahot Sara thanks ...I am always recommend your channel to my friends

[@MDataFinnovatics]

Thanks Kadar. I appreciate your efforts!!

[@nageshkaushik315]

Good

[@MDataFinnovatics]

Thank you Nagesh!!

[@ramkumarchourasia8030]

Very 👌

[@MDataFinnovatics]

Thanks Ram ji!

[@jkyadav77]

Sir aap kai video or teaching methods so different to other others. your video direct tech on mind ..

[@MDataFinnovatics]

Thank you Joginder Yadav!

[@sharwjeetsah8951]

Fine

[@MDataFinnovatics]

Thank you!

[@sujaypaul369]

The masterpiece that I am watching right now..❤️‍🔥❤️‍🔥💐

[@MDataFinnovatics]

Thank you!

[@mehagha1021]

NYC video

[@MDataFinnovatics]

Thank you Mehagha ji!

[@cutoworld7425]

Very well explained and please choose formula also want to understand

[@MDataFinnovatics]

Sure Cuto World!!

[@manojpun500]

Tha way you teach is very easy to learn. Love from Nepal 🤘

[@MDataFinnovatics]

Thanks Manoj. It really means a lot when we get comments from outside India.

[@mohitshahi6924]

Gjb

[@user-wl1ub6uv7i]

Sir great meri problem apke dwara solve ho gyi thanks

[@MDataFinnovatics]

Thats great!

[@ombirsorout4763]

Very useful and easy to use

[@MDataFinnovatics]

Thanks, Ombir Sorout.

[@sadbinhabibibnabdullah6234]

Excellent

[@avnishrana7024]

wow bro great i like it

[@MDataFinnovatics]

Thanks Avnish Rana!!

[@ravindramaurya1629]

very nicely explained

[@MDataFinnovatics]

Thanks Ravindra!

[@nmmurthy365]

Super 👍

[@MDataFinnovatics]

Thank you 👍

[@mohammedashfar1466]

Excellent sir! Post more excel formula related videos. Hats off to your knowledge 🙏. Definitely you will reach 1 million subscribers one day 👍

[@MDataFinnovatics]

Thank you, Mohammed Ashfar for your good wishes!

[@daudsuleman5605]

sir pls a video through salary sheet vi lookup

[@shyamallrounder]

Boss yah reply diya to mera kaam ban jayga

[@shyamallrounder]

Sir mere pass dusri sheet hai problem yah hai ki neeche Supoose name Arvi ek or ho or salry 54000 ke aawa kuch or ho, Means 3 Arvi hai 2 delhi se hai unki different salary kaise nikalnge

[@deepshrivastava4397]

Bhai choose formula use kark bhi ho sakta hai na ye to

[@Gamingvibesop]

nice

[@MDataFinnovatics]

Thank you! Kindly help your friends and colleagues by sharing the link to this valuable knowledge. Additionally, feel free to recommend topics for upcoming videos. Your suggestions are greatly appreciated!

[@daudsuleman5605]

Month wise 5 to 10 worker for the month Jan,Feb,Mar, etc , Dynamic sheet

[@biswarupbhattacharjee3183]

Sir, Help me out to make my invoice " Same product with two different values" Thank u

[@MDataFinnovatics]

Please email us with your detailed query.

[@abhishekshinde1086]

Sir please solve this question If c- code is not present than display "retired" using vlookup Please sir

[@MDataFinnovatics]

Hello Abhishek ji, to be honest the question is not clear completely. But still you can try this formula =IF(VLOOKUP(A1,G:H,2,0)"C code","Retired","Nothing") Let me know if you have some other requirement.

[@vimaldewangan9309]

Sir mere pass ek source data hai jisme invoice number duplicate hai but order number alag alag hai invoice value bhi alag hai. ab mujhe apne sales register me invoice number ke samne value pick karna hai kya hum Aisa kar sakte hai kisi furmula ke dwara.

[@pankajknowledgeworld]

Vlookup and match formula लगाव हो जाएगा..

[@muhammadwaqar4587]

But if name and city are same then?

[@MDataFinnovatics]

If the name and city are same then that is only one condition. As I said the unique identifier (column) which you are creating must be unique.

[@sulemanali3750]

Vlookup k formula ko fix kaise kre or bar bar formula na laga k ek hi bar me click and drage ho jaye

[@MDataFinnovatics]

Hi Suleman, fix karne ke liye pehle dekhna padega ke problem kya hai. Drag to karna padega mere bhai, otherwise need to write a code in VBA agar automate karna chahte ho to.

[@devdattpowale939]

Muje mid ka formulla nahi aata

[@MDataFinnovatics]

Watch this video - kzbin.info/www/bejne/aoGygGqPZqyff9k, kzbin.info/www/bejne/nIXOlImbh9CNnMU

[@pankajknowledgeworld]

एक तो आप लोग जब भी वीडियो लाते हो एक दो चार हेडिंग से उपर Data नहीं लाते.. Vlookup लगाया हो गया.. Bajao ताली.. एक तो विडिओ में बड़ा डाटा लाओ. Complication लाओ.. ऐसी video देखनी है तो short video देखेंगे.. इससे तो अछा.. Second is जब vlookup प्रैक्टिकल करते हैं थोड़ा सा बड़ा हेडिंग wise डाटा होता है तो colom गिनते गिनते दिमाग में पांच डिग्री बुखार आता है इसलिए हमेशा vlookup and match साथ में दिखाओ.. Smart विडिओ लाओ ताकि लगे कि इसके चैनल पर आए.. कुछ नया दिखायेंगे..

[@MDataFinnovatics]

Thank you, Pankaj, for your comments. We use data with less columns so that we get more space, and we can explain better in the blank area. But still, we will try to make videos as per your suggestions.

[@pankajknowledgeworld]

@@MDataFinnovatics at least 10 coloms dikhao toh आपको भी पता चलेगा कि colom गिन गिन कर कैसे vlookup करते हैं.. घण्टों का काम दिनों में होगा

[@MDataFinnovatics]

There is no need to count the columns while applying vlookup formuls. Jab bhi aap vlookup ka formula lagate ho, table_array me range select karte ho to range ko chodne se pehle wo aapko right me dikhata hai ke kitne rows and columns select kiye hai like 10R x 13C. So, aap waha se automatically dekh sakte ho, columns ko count karne ki jarurat nahi padti hai.

[@pankajknowledgeworld]

जैसे 10 heading की एक टेबल है और उसकी फर्स्ट heading यानी सीरियल नंबर से किसी रिपोर्ट में पांच नम्बर की हेडिंग तो किसी मे आठ नम्बर की हेडिंग की वैल्यू डिस्पले करानी है और सेल Lock unlock बार बार नहीं करने. अब गिनकर दिखाओ values बार.. लाओ video तब देखते हैं किसी ज्यादा हेडिंग की तीन चार रिपोर्ट इसी फार्मूला से करके दिखाओ

[@MDataFinnovatics]

For that you can use Vlookup + Match agar kafi columns hai jisme value chahiye to. Columns kitne hai, manually ye count karne ki koi jarurat nahi padti.