Vlookup with IF Formula in Excel in Hindi
Vložit
- čas přidán 12. 09. 2024
- 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
GREAT SIR G! YOU ARE DOING THE BEST.
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
What a lovely video
Excellent way sir ! God bless you.
🙏🙏🙏 spectacular
Thank you so much. I like the way you explain excel steps. Your explanation is just like excel formula =simple and easy to learn.
Thanks Ricky
बहुत अच्छा लगा लाजवाब
Thank you Sir aapne bahut acche se sikhaya. 😊🙏👍
Sir, Tomorrow I will go for MIS Executive job Interview. 😊
Thank You Sir 👍
Verry nice
Sir .... single like not enough for you video's.
Nice video
Wonderful sir thank we use index and match like this?
Can we use match in same formula?
Thanks
Great Sir
Sir agar dono row me number he to kese lagega
बहुत ही लाजवाब फार्मूला है लेकिन सर कोई और इसका कोई शॉर्टकट है जो शार्ट तरीके से काम करके लंबे प्रोसेस को आसान बना सके
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.
Wao
Superb trick sir
सर अगर जब एम्पलाई नंबर रिपीट हो रही हो अंतिम एंप्लोई नंबर का रिकॉर्ड निकालना हो तब कैसे करेंगे।
Great
Nice vedio sir
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
agar dono mein no. ho to ISTEXT ki jagah kya formula use karenge?
(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?
Hello sir,
Hvlookup, index explain kr do sir
Kya is formula Ko jyada column s k liye use Kiya ja Sakta hai.
Ek table ki figure ko different table se compile kaise karein
Thank you sir 🙂
Welcome Himanshu ji
Optional subject result formula batao plz
Sir, agr hum ye formula jyada columns pe kase apply kre
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
Hi Sir, Ihave a data with two criterias im unable to do vlookup with if function can u please help me on this..
Sir ek Imp. chiz btana to bhool gye,,ki ye form. if with vlookup hum kab use krte h?? Rply pls......
Sir, can you also add in which scenario above formula can be used ?
I have 1 query related to my data can you help to resolve this.
Is se easy he double vlook up..
Sir agr id ke jagah koi text rhe to kon sa formula lgayenge
This formula doesn't work Excel 2007 why?
I think it can be achieved by using DGET function
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.
What if both lookup values are in test or number
Sir me tally ko excel per kaam kerna chata hu
I want to get name by Vlookup behalf ID and don't use choose function, index function and match functions
Sir college mein fees mgt kaise krte hai excel mein video bnaye sir pls 🙏reply
Sure
@@GuruJiisir pls as soon as possible........
advance excel formulaS uplood korun . all advance excel formulaS uplood korum.
Sir i have a pic of data. I need a formula for that
Answer me error aa rahe
अगर 100 बच्चों को 22 टीचरों के ग्रुप में बांटकर शैक्षणिक भ्रमण पर ले जाना है यह कैसे संभव होगा कि प्रत्येक टीचर पर इन 100 बच्चों में कुछ संख्या में छात्र आ जाएं और वह छात्र और टीचर अपने एक ग्रुप में रहे इसी तरह से सारे बच्चे सभी टीचर पर मैनेज हो जाएं कृपया बताएं
Aager id phle no pe hui to 😇
agar Sameer naam likhe toh?
Gourges istext
Thanks