Vlookup with IF Formula | How to use if and vlookup functions together in excel in Hindi
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2024
- Learn How to use IF Formula With Vlookup in Excel to use conditional Vlookup.
How to Use Vlookup With If Formula in Excel. When there is a condition like yes or no in vlookup data set then most people don't know how to apply IF Formula in Vlookup and thet end up making two data sets for the same that is not required and can be done in single if formula and the vlookup formula together.
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. .
#ifwithvlookup #vlookupwithif #Innozant #Exceltutorial #vlookupformula
thats wonderful sir, the work you are doing might be your hobby, but this can make someone's life bright. Koti koti pranam sir
Thanks Deepak,Really means a lot to me dear.Happy learning
Super star of excel. ❤️❤️♥️♥️
Thanks for your appreciation dear
I saw many vlookup functions before but this one is really different example and very nice Sir..
From when I heard about your channel with my friend I am fan of yours teaching style... 👌👌
Thanks Sandeep Ji .. Really means a lot to me.Happy learning
Sir, You are the best teacher so far I have come across, Not any teacher in the whole UK can match your technique and style!! You would not know how you are shining through!
Thanks dear.Keep Leaening
Your Teaching style is very very different from all very nice Sir.
Thanks dear.Keep learning
Superb Sir., Superb explain
Thanks Khan sahab
Sir u r my favourite teacher in excel ...
Thanks dear
Sir Apka har videos kamal ka hota hai.. Sikhne me maza aata hai. 🙏
Thanks Pradeep Ji..Happy Learning dear.Seekhiye aur life me aage badhiye.🙏❤️🙂
Omg! what a wonderful explanation! if someone forgets , that explanation will help him to remind every thing again
very nice , keep it up
Thanks Jaishri for wonderful feedback.It really motivates me a lot,Will always try to make the Video that really enhance your knowledge.Once again thanks for go your precious time and watch our videos and learn from there.
Crystal clear ji! Dhanyawad 🙏
Thanks Mira..❤️God bless you...Never stop learning
Sir apke video post krne ke 3 saal bad dekh rha hu..lekin formule ki mehak aj bhi taza h 😅 superb maza agya
Thanks dear..Keep learning
Your way of explanation is very nice. Salute you!!!
Yar kya kamal krte ho!.. Qasam se koi jawab nahi!
Thanks Zahoor sahab.🙏❤️
Sir aapki teaching style amazing..love you sir
Thanks 👍❤️
Wow sir I am your big fan outstanding
You are different from others ... Great master
Thanks Ankit.Really means a lot that me
Excellent teaching style very good sir, this function is very useful
Excellent combination Sir. Thank you
Every concept clear and unique questions for practice and wonderful sir 🙂
So wonderful method sir
Thank you so much
ये विडियो कमाल है 👍
Thanks Dear
Fantastic 🎉❤
Such a nice video, Now I am ready for my ICT exam!!
👍
bahut badiya
Very Good...this problem can solve by many other method
Thanks Kamal ji,You like the video and start learning from there.Happy learning
hELLO, I must say that u r too good at explaining excel and also your examples are very practical and non-hypothetical
Thanks dear.Really means a lot to me
Thnx sir for excellent example plzz hume aise hi ache example dijiye🙏🙂👍👍
Thanks Sujata, Welcome you to experience the taste of success.
Yes dear humesha Meri koshish hogi ki harek video knowledge bas leke again.jiise apka skills enhance ho aur ap life me aage badhen.
Abhi to bht saare playlist add hona hai.. Thanks for choosing Innozant for Learning.😊🙏❤️
@@Innozant thank you so much sir 🙏👍🧡
Mind blowing 🤯
Thanks
Very nice sir
You are good teacher sir; I have one question what to do if both values are text? Suppose we are looking value is customers last name and first name.
Great sir
Excellent explain
U r awesome sir,itni achi explanation abhi tak kisi ne nahi diya. Thanks for the videos. Itne din tak aap k videos my kyse miss kari...🤔🤔
🙏🙂♥️Thanks itne pyare comment ke liye Saath hi Video Jo Pasand Karne ke liye.Aap step by step In sequence videos se learn karna start kijiye..apko Kahin fees deke course join krne ki jarurat nhi hogi AISA main umeed krta hoon.Happy learning..Koi query HOTA hai practice krne me prob you ma connect me on Telegram I'd -@innozantofficial
Thank you
So much 😘😘
Wonderful sir, a unique way to reaching
Thanks ❤️
Thanks a looot for practice file too,those file really help in understanding.
Yes Jaishree you may always fine practice file and also conncet with me every Sunday for doubt session via zoom virtual live session.
You are great sir
awesome example and explanation too!
Nice. Thank you
Super grate Sir
Thank You so much
Nyc Sir ji
Bahut badhiya
superb
Superb sir
Thanks Anjali
Fantastic sir 👌👍
Very nice and informative video. Thanks sir. If I want to highlight entire row with the result then how it is possible because when I try to highlight row it only highlight the last cell
Wow sir.. amazing explanation..
I want to see all the videos and learn..
I am gradually becoming an expert in Excel
Nice video sir
Wonderful
Mind blowing sir want mores....
Thanks Ajit ji🙏❤️
You are Genius I am trying to join either your virtual class or Offline class within two or three months. 🕙I am arranging money to join.
Sure dear
Thank you sir
gazab sirrr
The teaching methodology is excellent, U make concepts so simple to understand. Great Work. Keep it up !! :)
Thanks Jhaji..Keep Learning ♥️
Awsome😊
Awesome 😆
❤❤❤ owsummmm
Outstanding
Thanks dear👍❤️
Excellent Sir
Thanks ❤️
Nice video and with funny explanation...
Thanks Soniya.We welcome you then experience the taste of Success with Innozant-Seed of Success ❤️
Sir mujhe ek baat nhi samajh ayi ki yaha ISTEXT hi kyu chalaya ISNUMBER bhi to chala skte the pls confirm ?
Reply kijiyega sir.
Very nice
Thanks Aditya
very great sir
Nice bro
Thank You Bro🙂
Awesome sir 👍✅
Thanks Ganesh Ji
THANKS SIR
Thanks Sarita
Informative.
Nice
In this video Last incentive ki topic m nested if kaisa kare pls boliye
Super say upper
Thanks Malik Sahab
Bhut badiya .. Sir ek formula bataye jisme 1st column me 3-3 value h or 2nd me bhi 2-2 value ho lekin 3rd column ka data lena ho to kaisa formula use kre.plz help me
Your skill with presentation set you apart from everyone else. 👍🙏🏻
Really means a lot to me..Keep exploring 😊
So nice Sir.
Thanks Sanoj
👌🏻👌🏻👌🏻 super video
Sir please excel full videos banaiye
Thanks.
Thanks Rajender ji
Awesome 👍😎
Excellent 👍
Thanks Shashank
Please make a video on XIRR and IRR formula
👍❤️
Super
❤️👍
Great👍
When u talk about core excel plz let the clear core excel functions in breafly so that viewers can be easily understand.
Very good Sir
Thanks Sir.We welcome you experience the taste of Success with Innozant-Seed of success.🙏Happy Learning
If function ke vlookup 3 bar use kar sakte hai. Mere pass 3 shop hai aur har shop me product smae hai but price difference hai aur mujhe if function k sath use shop wise found karna hai
Kahe ka discount ek to baise hi tangi chal rahi hai 😂😂😂😂😂😂
Sir I am learning a lot from your videos ☺️☺️😊😊
Hahahaha..Keep learning
sir agar dono column mein number ho text na ho aur koi bhi number type karne mein detail aa jaye to ISTEXT ki jagah aur kya use karenge??
Superb
THANK YOU!
Super 👌
Sir vlookup ke saath concatenate function ka used karke batao example ke saath
Ok Jha Ji ..waise interview cracker series me already hai vlooukp with concatenate video.
Good
🙏👍
Fabulous videos🤩
Thanks Sharmaji for your appreciation.Keep wathing and share .
@@Innozant u wlcm jha jii
we can use match function also
respected sir i realy like your channel
please help me i prepred 89 days daily wages letter in automation
sir...incentive column ka last 3 value N/A a raha hy
Please sumif ko multiple tables and sheets ma kessy lagatay hain indirect k sath yah choose yah name and range k sath please i need this
Already vidoe hai indirect ka
Sir mujhe MIS ki job karni hai please suggest important formula
Complete Course kariye steo bye step from Basic excel to advanced.Aap interview me puche gaye har sawal ka answr de payenge ydi achese course steo by steo krengr to