vlookup with IF Formula in Excel | How to use IF and Vlookup functions together in Excel

In this video learn vlookup with IF Formula in Excel
1. Vlookuup with IF formula example
2. How to use IF and vlookup functions together in excel
3. If function with vlookup example explained
4. Best use of Vlookup with if real time example
5. Tax Exemption example usning vlookup and if in excel
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Lookup Functions(Beg-Adv) VlookupwithIfFormula.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookupwithifformula#vlookupwithif#Innozant #vlookupfunction

[@ManishVerma-gg8xl]

सर बहुत सही मान गए आप सच मे ग्रेट हो vlookup की play list मे बहुत मजा आ रहा है हर tutorial मे बहुत कुछ नया सिखने को मिल रहा है।
बहुत बहुत आभार आपका आदरणीय 🙏🙏

[@Innozant]

Aap harek playlist complete karen.kuch na kuvh naya seekhte rahenge aap

[@balamira297]

Namaste Sir!Nobody can be more clear than you! Bahut bahut Dhanyawad sir aapko!

[@Innozant]

Namaste Mira,Aapko bhi dhyanyabad itna lecture ko Pasand Karne ke liye aur usse BHI jyada main khush isliye ki ye videos Aapke life me value add Kar Raha hai aap seekh rahe hain isse aur life me aage badhne ki koshish..Never stop learning..HV a wonderful career ahead.❤️❤️🙏🙏👍👍

[@raj28san]

Hi Sir, Thank you very much for this video, you teach us so nicely. You truly a very good teacher. God bless you Sir abundantly.

[@kapilkashyap7026]

Nice sir you are providing 👌 quality of education in this platform. Your video always delivers quality of content.tnx sir

[@Innozant]

❤️❤️

[@midnajo437]

Great Video. Thanks a lot for sharing your knowledge.

[@priyankachamoli1712]

Thankyou sir, you are the best teacher in the world.

[@Innozant]

Thanks Priyanka for such a valuable appreciation..❤️🙏 Really means a lot to me..Gor bless you.
Recommend you take start your learning journey from playlist Basic Excel onwards.👍❤️

[@AvinashSingh-im4oc]

​@@Innozant hello sir I am Big fan of you apke videos dekh kr Maine Ye Naya Formula Bnaya haya please isse V ajam ke dekhea thoda Bda Hai lekin Excell Smjne walo ke Lea Assan hoga =IF(MAX(IF(F143=$B$144:$B$152,$C$144:$C$152))=MAX($C$144:$C$152),IFERROR(VLOOKUP($F143,$B$143:$C$152,2,0),"")&" its Maximum sold product ","its not masimum sold prodcut") is formula se Apko ye v Pta Chal jayga Ki Maximum value Hai kitna aur Sath hi sath he V message ajayega ki ye Maximum sold Product hai,ager wo Maximum sold Product nahi v hai To v ye Message ajayega ki it's not Maximum sold Product lekin Formula Execute krne ke Cntrl +shift + Enter dba na hoga Kuki ye Arrey Bn Chuka hai Please use dekhea

[@princejoshaf336]

Thank you very much sir for your support you are my Excel guru 💝 love you sir❤

[@solehashaikh5749]

Thank You sir ji..you are a great Teacher :)

[@arslan_TM]

Best channel for pro Excel tips,
Bro love from Pakistan.

[@Innozant]

Thanks Dear.
God bless you

[@rajasekaranrajasekaran5048]

Super sir several different formula very useful Thank you

[@kishorpanara4191]

Sir very nice you are magician

[@Innozant]

Thanks Kishore for this lovely feedback

[@sandeepaswal8944]

Sir Namstai Thanks for the detailed explanation, very helpful. You are great. Your step to step so easy. Teaching so mind blowing.

[@Innozant]

Thanks Sandeep Ji,Learn step by step In depth.

[@ManishVerma-gg8xl]

आदरनीय IF and VLOOKUP का second approach को use कर के मै portal की GST 2B की excel sheet को अपनी tally की purchase वाली excel sheet से मेच करता हु बहुत जबरदस्त रिसल्ट आता है जो किसी भी साफ्टवेयर से possible नही होता है और इस tricks को मैने अपने खंडवा शहर के मेरे जानने वाले CA को भी शेयर किया है ।
🙏🙏🙏🙏

[@Innozant]

Wow...Great Manish Ji👍

[@Pixindesign]

Apka video sabse alag hota hai best and best.
Sir if function se sath aur dusra dusra function ka ise karke batate 🙏please

[@Innozant]

Hain jai video if association ke

[@sarkarji960]

Sir you are genius, really hats off to you

[@Innozant]

Thanks dear

[@AnandKumar-mi9fm]

You look like Hero Akshay Kumar sir, And your teaching skills are real hero.

[@Innozant]

😊❤️ Thanks Anand ji..Never Quit..Learn and explore.Have a wonderful career ahead

[@jaspalrana9541]

You are the genius 😉 sir.

[@Innozant]

Thanks Jaspal Ji for such a wonderful compliment.

[@mdshahed6758]

Thank you vary match, I am look a solution, For three days. Now you give this.

[@Innozant]

Thanks 👍

[@kalpeshrathod9205]

Hi.. can you please provide more ideas with xlookup

[@AkashKumar-tu4fm]

Thank you so much sir ❤

[@superNareshg]

Excellent video.
Thank you so much sir.
🙏🙏🙏

[@Innozant]

Thanks dear

[@shurawat8650]

amazing video sir

[@sudhakardevaraj6066]

Awesome bro all video are good very easy understand thanks bro

[@Innozant]

Thanks Sudhakar ji for such a valuable feedback.Will always try to make awesome learning content for all of you.♥️🙏🙂

[@ADangergaming]

Ap great ho sir.

[@jamilhfl]

Excellent

[@dhakafady774]

thanks a lot sir

[@aakankshasrivastava9497]

Superb Sir..👍

[@Innozant]

Thanks Aakanksha,Nice to see that you never miss to watch the new video uploaded.Happy learning step by step.Tc

[@amitapattanaik1071]

Cute & sweet example & explanation

[@Innozant]

Thanks Salil ji

[@AB-ex8ck]

Very nice..

[@nirmalrana9439]

Great sir

[@chikoogangraj7990]

Aisa koi sikhata hai kya gajab tarike se 🙂🙂🙏🙏🤘🤘👌👌

[@Innozant]

Thanks dear..Keep learning

[@rahulrakshe1988]

Nice teached

[@rameshbhuva2668]

Very nice sir but if ki multiple formula ko vlookup ke sath kaise chalate hai uska ek video bana dijiye

[@maddy2613]

Thank you sir

[@himanshudewangan45]

Very nice use full video, sir g दो शीट के डाटा को match कराने के लिए index एवम match function ka formula bataiye na pls

[@Innozant]

Bataya hua hai dear..watch full series

[@ManojGupta-nl8fj]

Very nice sir👌👌👌👌

[@atulshukal4072]

Very good Sir ji

[@Innozant]

Thanks Atul🙏♥️

[@kinghundred]

very great sir

[@RahulKumar-ly6ly]

Thanks sir very helpful video

[@Innozant]

Thanks Rahul..Happy learning ❤️

[@Ranjitmaurya_M]

Sir aap bahut achha padate h 🤙

[@Innozant]

Thanks dear🙏❤️

[@Pavel102025]

Super vedio

[@gauravbhatia7987]

Thnq sir so much

[@vijaysahal4556]

superb sir 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay

[@tayyabyarkhan1048]

❤ from Pakistan

[@badboy4669]

Nice 👍👍👍

[@Innozant]

Thanks Samat🙏❤️

[@achalrajput4173]

Sir, last example m max sale alag s kyu nikali h use bhi if function k andar hi chla dete to aur bhi accha lgta. Sir aapki interview cracker series s mene bhut kuch seekha h aur abhi bhi seekh hi rha hu itna to koi institute wala lakho Rs m bhi nahi sikha payega.. m jldi hi aapka course lene ja rha hu ...Thank you sir 🙏

[@vijaysahal4556]

This one lovely sir 👍🏻👍🏻👍🏻👍🏻

[@Innozant]

Thanks Vijay Ji❤️❤️

[@devendergusain8974]

Behtareeen.........

[@Innozant]

Thanks ❤️❤️❤️🙏

[@yuvarajadhikari4463]

Hi Sir
Thank you so much for your video. I could not understand the logic to put 1 at the end for vlook up. Is it same if we keep "false" or 0 ?

[@Innozant]

1 for approximate match and 0 for exact match dear ,kindly watch our vlookup videos series

[@durjoyghosh236]

Sir, In If command, True main ek vlookup and false mein ek vlookup deke combind ka video dijiye plz

[@RAJKUMAR-dv6pf]

Very good

[@Innozant]

Thanks dear

[@kanchanyadav1240]

YES,i UNDERSTOOD

[@Innozant]

Good 👍❤️

[@saeedakhtarkhan5481]

Good

[@priyankasharma-xz9io]

Very nice video sir

[@Innozant]

Thanks Priyanka

[@johndas8173]

Sir isme subtotal ka formula add karke video banao

[@spine-x8163]

I am your first Subscriber sir

[@Innozant]

❤️👍

[@kalwantsingh4997]

Very nice 👌

[@Innozant]

Thanks Kulwantbju❤️🙏

[@pankubisht3495]

Thanks sir

[@Innozant]

Thanks Panku🙏❤️

[@sonalmenaria5766]

I am watching your video
I am giving the answer of pro quest 3
Related to this video

[@Innozant]

Ok Sonal,You already attach your solution file of Proquest 3 to Google forms ?kindly upload it on the Google form link given in Proquest video description ❤️🙏

[@kailashpatel7742]

Thanks

[@Innozant]

🙏❤️

[@kulwantrana6540]

What do I do if the salary is not a round figure?

[@user-ej9pz5zd5i]

Use round formula

[@RohitKumar-cc7zi]

Owsom sir,

[@Innozant]

Thanks Rohit ji..GN🙏👍❤️

[@karankapoor200]

you are great teacher sir🙏🙏
Sir Excel all function par eak video banya please. or kuch assa tips bataya jo hum kisi say puch to wo na bata pay is hum bata payaga ki please innozent KO subscribe kara or like and share kara please .
please sir request h Ki apa Mari baat par focas karaga . kuch computer ka short cut tips or Kuch Excel ka tips please🙏🙏🙏🙏😭

[@Innozant]

Jaroor karan..kitne aise chaiye aapko tricks jo sirf aapko aata hoga aur kisi aur se pucho to wo bole ki..omg aisa bhi hota hai ?
Tips and tricks me aise sawal ka jawab leke aate rahenge dear
Short cut ke video to banaye hain aur bhi bana denge

[@sagarmathur3535]

Sir agar isi mein max bhi lagaye to kaise kagega.. vlookup ,if n max combined.. without using helping column of max sales

[@Innozant]

Already batay H aage ke videos me vlookup nke saath max ka use dear..steo by step seekhiye ..

[@Harish.Prasad.Semwal]

2:40 3:34 5:37
9:27

[@keshavhotwheelscollection]

Sir aapne max sales ka cell ko freeze kyu kia? taaki agle cell me na jaa paaye isliye?

[@yogeshrao5924]

Actually apka vedio keval vedio nhi lgta lgta h aap class me pdha rhe he 😊❤

[@Innozant]

Thanks

[@shahidjawaid6137]

What if lookup value in 2 cell and lookup array in 4 columns, how do will apply formula ?

[@Innozant]

Concatenate both lookup value and with the help of helper column you may find the result

[@virendersroha1754]

Osm

[@Innozant]

Thanks Viru,have a great day ahead

[@shyampal4027]

Hello sir,
I want pic a last column value in multiple item( like last buying price)

[@Innozant]

Shyam Pal Ji..Aap Lookup playlist me Jake ZZZ lookup Ka video Dekh lijiye Aapke Question Ka answer mil jayega dear.🙏❤️❤️👍

[@KumarRaj-my2op]

Sir,If my lookup is same and I have to take data from two sheets,How I will apply vlookup in this condition.

[@Innozant]

Duplicate vlookup using the help of helper column with countif

[@tusharpawar3557]

sir vlookup ke sat sumif formula la kese use kare pls video bnaye

[@Innozant]

Hai alredy interview cracker series me..koi nhi alag se BHI Bana denge video..👍❤️🙏

[@tusharpawar3557]

@@Innozant ok sir

[@muhammedjan9463]

Hi sir am from Pakistan. Sir Mera aek question Hy apse. Mere pas aek data base hy jis me student name, or kuch subject hy. Sir mera condition ye he ke jis B name ko me lookup karu Hus ke wo marks "sum" ho Jo "even" hy. Please sir give me a solution ❤

[@safdarayaz3030]

Sir fee slip bananay kay leya help chaheya ta please how i contact with you

[@amiitmish3]

In one of video I have seen put vlook up put into memory in that even if u look up sheet closed ,populate data will nit become zero .what was the method as I am not able to find that video

[@Innozant]

Select table array press F9 ,When data is in expanded form save the formula as it is

[@amiitmish3]

@@Innozant thanks I am so kind of u ,little help can u give me link for that video
Really very helpful

[@amiitmish3]

Plz share link

[@baldevsolanki36]

Hello sir,
Vlookup formula ke sath 2+ bar if formula kese use kar sakte he

[@Innozant]

Situation batayen kaise use Krna hai..will guide u

[@basantkumarchandola2897]

एक्सेल फॉर्मूला में किसी भी माह के प्रथम, द्वितीय, तृतीय और चौथे शुक्रवार को कैसे creat करें

[@VPRAJ89]

Sir ji Ram Ram
Mujhe ex formula batana
Format bhejna tha aap ko aur mujhe ye batane ka kast karen ki esi .075% Nikal jaaye aur ek jagh No karen toh esi deduct na ho

[@spine-x8163]

Hii sir

[@heeralalkumawat2132]

🎉🎉🎉🎉🎉🎉

[@sudhanvamahamuni3191]

Instead of direct explanations and on point talk; you take too much time.

[@Innozant]

This is in depts course course content in sequence,Need to explain the concept to understand .It is not just a youtube video to gain views.

[@mdsani743]

Thank you sir

[@bhoopendraraghav9781]

Excellent

[@Innozant]

Thanks Bhoopendra