Vlookup with IF Formula | How to use if and vlookup functions together in excel in Hindi

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

[@deepakchauhan4974]

thats wonderful sir, the work you are doing might be your hobby, but this can make someone's life bright. Koti koti pranam sir

[@Innozant]

Thanks Deepak,Really means a lot to me dear.Happy learning

[@RMKserve]

Super star of excel. ❤️❤️♥️♥️

[@Innozant]

Thanks for your appreciation dear

[@SandeepSingh-lh4uu]

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... 👌👌

[@Innozant]

Thanks Sandeep Ji .. Really means a lot to me.Happy learning

[@mgrover5125]

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!

[@Innozant]

Thanks dear.Keep Leaening

[@malcolmdevadas5903]

Your Teaching style is very very different from all very nice Sir.

[@Innozant]

Thanks dear.Keep learning

[@AhmedKhan-ql2oy]

Superb Sir., Superb explain

[@Innozant]

Thanks Khan sahab

[@Unfiltered_ind]

Sir u r my favourite teacher in excel ...

[@Innozant]

Thanks dear

[@PradeepKumar-hd1ty]

Sir Apka har videos kamal ka hota hai.. Sikhne me maza aata hai. 🙏

[@Innozant]

Thanks Pradeep Ji..Happy Learning dear.Seekhiye aur life me aage badhiye.🙏❤️🙂

[@jaishrisaxena1083]

Omg! what a wonderful explanation! if someone forgets , that explanation will help him to remind every thing again
very nice , keep it up

[@Innozant]

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.

[@balamira297]

Crystal clear ji! Dhanyawad 🙏

[@Innozant]

Thanks Mira..❤️God bless you...Never stop learning

[@ronsins1148]

Sir apke video post krne ke 3 saal bad dekh rha hu..lekin formule ki mehak aj bhi taza h 😅 superb maza agya

[@Innozant]

Thanks dear..Keep learning

[@tapa671]

Your way of explanation is very nice. Salute you!!!

[@zahoorsarbandi2982]

Yar kya kamal krte ho!.. Qasam se koi jawab nahi!

[@Innozant]

Thanks Zahoor sahab.🙏❤️

[@paulpal6599]

Sir aapki teaching style amazing..love you sir

[@Innozant]

Thanks 👍❤️

[@shivamkr3030]

Wow sir I am your big fan outstanding

[@Knowledge-wf2vw]

You are different from others ... Great master

[@Innozant]

Thanks Ankit.Really means a lot that me

[@rashidiqbal7547]

Excellent teaching style very good sir, this function is very useful

[@Rameshkumar4567]

Excellent combination Sir. Thank you

[@VikasSingh-em3ol]

Every concept clear and unique questions for practice and wonderful sir 🙂

[@rafatali6058]

So wonderful method sir
Thank you so much

[@anandmansoresong9091]

ये विडियो कमाल है 👍

[@Innozant]

Thanks Dear

[@jitenkalam6679]

Fantastic 🎉❤

[@RushiShah2007]

Such a nice video, Now I am ready for my ICT exam!!

[@Innozant]

👍

[@narinderkumar7831]

bahut badiya

[@kiituniversity115]

Very Good...this problem can solve by many other method

[@Innozant]

Thanks Kamal ji,You like the video and start learning from there.Happy learning

[@dwarkaheightschs7764]

hELLO, I must say that u r too good at explaining excel and also your examples are very practical and non-hypothetical

[@Innozant]

Thanks dear.Really means a lot to me

[@sujatamohanty9345]

Thnx sir for excellent example plzz hume aise hi ache example dijiye🙏🙂👍👍

[@Innozant]

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.😊🙏❤️

[@sujatamohanty9345]

@@Innozant thank you so much sir 🙏👍🧡

[@rakshitkumar2330]

Mind blowing 🤯

[@Innozant]

Thanks

[@nirmalrana9439]

Very nice sir

[@Rahul_16k]

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.

[@prolaypaul5542]

Great sir

[@ManojSingh-wt9de]

Excellent explain

[@rounaqara5737]

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...🤔🤔

[@Innozant]

🙏🙂♥️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

[@rounaqara5737]

Thank you
So much 😘😘

[@dssaini689]

Wonderful sir, a unique way to reaching

[@Innozant]

Thanks ❤️

[@jaishrisaxena1083]

Thanks a looot for practice file too,those file really help in understanding.

[@Innozant]

Yes Jaishree you may always fine practice file and also conncet with me every Sunday for doubt session via zoom virtual live session.

[@udaykakde4595]

You are great sir

[@shashankku.1469]

awesome example and explanation too!

[@WST16]

Nice. Thank you

[@durgeshpratap5019]

Super grate Sir

[@lifeignite2048]

Thank You so much

[@asdagar9633]

Nyc Sir ji

[@nirmalrana9439]

Bahut badhiya

[@badripatra2504]

superb

[@aanjalisurve4962]

Superb sir

[@Innozant]

Thanks Anjali

[@reshmanikam5992]

Fantastic sir 👌👍

[@ManishShori]

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

[@jyotijha7910]

Wow sir.. amazing explanation..

[@vinothkumarmanoharan2317]

I want to see all the videos and learn..

[@rinturoy8014]

I am gradually becoming an expert in Excel

[@ankitsinghel1116]

Nice video sir

[@kelkarsm]

Wonderful

[@ajitraj51]

Mind blowing sir want mores....

[@Innozant]

Thanks Ajit ji🙏❤️

[@amazingindiabyshiva8357]

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.

[@Innozant]

Sure dear

[@ruksar2189]

Thank you sir

[@shurawat8650]

gazab sirrr

[@Sunset.k79]

The teaching methodology is excellent, U make concepts so simple to understand. Great Work. Keep it up !! :)

[@Innozant]

Thanks Jhaji..Keep Learning ♥️

[@VimalKumar-ih6ik]

Awsome😊

[@sonukumar-xp5sd]

Awesome 😆

[@tayyabyarkhan1048]

❤❤❤ owsummmm

[@imranibrahim8247]

Outstanding

[@Innozant]

Thanks dear👍❤️

[@Rejuanhaque]

Excellent Sir

[@Innozant]

Thanks ❤️

[@soniyaunni1975]

Nice video and with funny explanation...

[@Innozant]

Thanks Soniya.We welcome you then experience the taste of Success with Innozant-Seed of Success ❤️

[@amazingindiabyshiva8357]

Sir mujhe ek baat nhi samajh ayi ki yaha ISTEXT hi kyu chalaya ISNUMBER bhi to chala skte the pls confirm ?
Reply kijiyega sir.

[@AdityaKumar-lq7nj]

Very nice

[@Innozant]

Thanks Aditya

[@kinghundred]

very great sir

[@rahulrakshe1988]

Nice bro

[@raghavkumar5042]

Thank You Bro🙂

[@Shradpatil02]

Awesome sir 👍✅

[@Innozant]

Thanks Ganesh Ji

[@sanakhan9169]

THANKS SIR

[@Innozant]

Thanks Sarita

[@Adeeluddin06]

Informative.

[@user-ys2xf1yu7h]

Nice

[@mohdsamiulrahman4453]

In this video Last incentive ki topic m nested if kaisa kare pls boliye

[@mamalik1088]

Super say upper

[@Innozant]

Thanks Malik Sahab

[@arunvishwakarma7722]

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

[@koushik4484]

Your skill with presentation set you apart from everyone else. 👍🙏🏻

[@Innozant]

Really means a lot to me..Keep exploring 😊

[@meditationmusic6482]

So nice Sir.

[@Innozant]

Thanks Sanoj

[@karankapoor200]

👌🏻👌🏻👌🏻 super video

[@loved787]

Sir please excel full videos banaiye

[@rajendardhar]

Thanks.

[@Innozant]

Thanks Rajender ji

[@focuspower2374]

Awesome 👍😎

[@shashanksingh5170]

Excellent 👍

[@Innozant]

Thanks Shashank

[@vedsingh6777]

Please make a video on XIRR and IRR formula

[@Innozant]

👍❤️

[@sarvodayaconventvidisha1757]

Super

[@Innozant]

❤️👍

[@ankitsinghel1116]

Great👍

[@naeemulhassan1426]

When u talk about core excel plz let the clear core excel functions in breafly so that viewers can be easily understand.

[@atulshukal4072]

Very good Sir

[@Innozant]

Thanks Sir.We welcome you experience the taste of Success with Innozant-Seed of success.🙏Happy Learning

[@Manikshil4]

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

[@nooropedia1950]

Kahe ka discount ek to baise hi tangi chal rahi hai 😂😂😂😂😂😂
Sir I am learning a lot from your videos ☺️☺️😊😊

[@Innozant]

Hahahaha..Keep learning

[@aayushagarwal8883]

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??

[@perfectlover9918]

Superb

[@shrikantbadge3978]

THANK YOU!

[@PUJARI16]

Super 👌

[@subhkantjha4564]

Sir vlookup ke saath concatenate function ka used karke batao example ke saath

[@Innozant]

Ok Jha Ji ..waise interview cracker series me already hai vlooukp with concatenate video.

[@gauravbhatia7987]

Good

[@Innozant]

🙏👍

[@nityasharma5923]

Fabulous videos🤩

[@Innozant]

Thanks Sharmaji for your appreciation.Keep wathing and share .

[@nityasharma5923]

@@Innozant u wlcm jha jii

[@suvajitkar6951]

we can use match function also

[@QamarAbbas-dq3fh]

respected sir i realy like your channel
please help me i prepred 89 days daily wages letter in automation

[@sayantankesh5767]

sir...incentive column ka last 3 value N/A a raha hy

[@muttiurrehman1579]

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

[@Innozant]

Already vidoe hai indirect ka

[@DheerajSingh-ox8uw]

Sir mujhe MIS ki job karni hai please suggest important formula

[@Innozant]

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