Vlookup with IF Formula in Excel in Hindi

Use Vlookup With IF Formula in Excel to use conditional Vlookup
Download Practice Files from wp.me/p7DKaP-1eF
How to Use Vlookup With If Formula in Excel. Many a times we are required to use vlookup based on a condition like yes or no but most people don't know how to apply IF Formula in Vlookup hence they end up making 2 data sets, which is not required and can be done in 1 single shot using the if formula and the vlookup formula together
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel- • 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners- • Learn Basic Excel Skil...
Learn the Basic of Excel for Beginners - • Learn the Basic of Exc...
10 Most Used Excel Formula- • 10 Most Used Excel For...
Learn Vlookup Formula For Beginners in Excel- • Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews- • 5 Excel Questions Aske...
Create Speedometer Chart In Excel- • Create Speedometer Cha...
Create Pareto Chart In Excel- • Create Pareto Chart In...
How to Create Dashboard in Excel- • How to Create Dashboar...
Excel Interview Questions & Answers- • Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy

[@noorqamar7580]

GREAT SIR G! YOU ARE DOING THE BEST.

[@kkk3097]

Dear sir salute to you as your excel.videos are amazing and also learning a lot from it hats off to you sir Really you are doing very nice job

[@dakshkumar873]

Thank you Sir aapne bahut acche se sikhaya. 😊🙏👍 Sir, Tomorrow I will go for MIS Executive job Interview. 😊

[@chetnagtak3639]

Excellent way sir ! God bless you.

[@catricky21]

Thank you so much. I like the way you explain excel steps. Your explanation is just like excel formula =simple and easy to learn.

[@GuruJii]

Thanks Ricky

[@AbhishekMishra-cr1tz]

बहुत अच्छा लगा लाजवाब

[@mahetabkhan6955]

What a lovely video

[@trivedikumarsonesh4194]

बहुत ही लाजवाब फार्मूला है लेकिन सर कोई और इसका कोई शॉर्टकट है जो शार्ट तरीके से काम करके लंबे प्रोसेस को आसान बना सके

[@wrongturnlima007]

Sir .... single like not enough for you video's.

[@unlimitedGK-om8bs]

🙏🙏🙏 spectacular

[@rohitarora3261]

Thank You Sir 👍

[@mahetabkhan6955]

Verry nice

[@artideshwal2089]

Thanks

[@RashidKhan-ei8mn]

Wonderful sir thank we use index and match like this?

[@godhan1000]

Superb trick sir सर अगर जब एम्पलाई नंबर रिपीट हो रही हो अंतिम एंप्लोई नंबर का रिकॉर्ड निकालना हो तब कैसे करेंगे।

[@satishhosamani8229]

Great Sir

[@poojaadnani2870]

Hi Sir, Can you please make a video with some real data which is really huge. As it will be good to see how the formula work on big practical data.

[@maheshvyas8087]

(1)Sir,how to exchange two rows automatically,(both rows with vlookup formula),if value in first is smaller to next row? (2)How to add serial no.in a cell after every click from drop down list.which is to be start from sr.no.1 on first day of every month?

[@ashokkumawat4810]

Hello sir, Hvlookup, index explain kr do sir

[@92kumarmanoj58]

Nice video

[@priteshkhamkar3975]

Can we use match in same formula?

[@parthopratimdas175]

Wao

[@jskcreation8208]

Sir agar dono row me number he to kese lagega

[@DilkiaawazAnita]

Great

[@himanshuratansrivastava]

Thank you sir 🙂

[@GuruJii]

Welcome Himanshu ji

[@kishorsahu7292]

Ek table ki figure ko different table se compile kaise karein

[@pranavaaryan9268]

Is se easy he double vlook up..

[@RohitKumar-uy7cx]

Nice vedio sir

[@vinodkarhade1711]

Optional subject result formula batao plz

[@Pradeepyadav-fj1dp]

sir Agar 1 column mai kuchh cell value hai but khuchh cell khali hai to khali wale pe vlook up kaise lagaye vlookup with isblank formula

[@aayushagarwal8883]

agar dono mein no. ho to ISTEXT ki jagah kya formula use karenge?

[@wearejokers5316]

Sir, agr hum ye formula jyada columns pe kase apply kre

[@GuruJii]

Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources

[@aminshah3181]

Sir, can you also add in which scenario above formula can be used ?

[@jasvinder1958]

I think it can be achieved by using DGET function

[@rajeshkumarsingh4844]

Kya is formula Ko jyada column s k liye use Kiya ja Sakta hai.

[@khushalbisht2831]

This formula doesn't work Excel 2007 why?

[@pramodbhatt6906]

Hi Sir, Ihave a data with two criterias im unable to do vlookup with if function can u please help me on this..

[@arvin4892]

Sir ek Imp. chiz btana to bhool gye,,ki ye form. if with vlookup hum kab use krte h?? Rply pls......

[@bajrangrana3014]

Sir agr id ke jagah koi text rhe to kon sa formula lgayenge

[@rakeshprajapati3248]

Hi, sir can you help me to put vlookup if it match with other cell like I have the modle and it have some parts but same parts is also available with the other model also but the price is different as per the model and we have variety of different parts.

[@shubhamaggarwal5029]

I have 1 query related to my data can you help to resolve this.

[@shahidjawaid6137]

What if both lookup values are in test or number

[@pradeeppundir8767]

I want to get name by Vlookup behalf ID and don't use choose function, index function and match functions

[@nidhitasaini5895]

Sir college mein fees mgt kaise krte hai excel mein video bnaye sir pls 🙏reply

[@GuruJii]

Sure

[@nidhitasaini5895]

@@GuruJiisir pls as soon as possible........

[@priyankagra]

Sir me tally ko excel per kaam kerna chata hu

[@madurgababueducationS60]

advance excel formulaS uplood korun . all advance excel formulaS uplood korum.

[@DheerajMarwal]

Sir i have a pic of data. I need a formula for that

[@hemantchavan4443]

Answer me error aa rahe

[@pahadistarhsb563]

Aager id phle no pe hui to 😇

[@SanjaySingh-tt5fv]

Gourges istext

[@sghai2125]

agar Sameer naam likhe toh?

[@sarvodayaconventvidisha1757]

अगर 100 बच्चों को 22 टीचरों के ग्रुप में बांटकर शैक्षणिक भ्रमण पर ले जाना है यह कैसे संभव होगा कि प्रत्येक टीचर पर इन 100 बच्चों में कुछ संख्या में छात्र आ जाएं और वह छात्र और टीचर अपने एक ग्रुप में रहे इसी तरह से सारे बच्चे सभी टीचर पर मैनेज हो जाएं कृपया बताएं

[@khrifat2319]

Thanks