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.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#ifwithvlookup #vlookupwithif #Innozant #Exceltutorial #vlookupformula

[@VikasSingh-em3ol]

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

[@RMKserve]

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

[@Innozant]

Thanks for your appreciation dear

[@tapa671]

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

[@Rameshkumar4567]

Excellent combination Sir. Thank you

[@rashidiqbal7547]

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

[@jyotijha7910]

Wow sir.. amazing explanation..

[@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.

[@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

[@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

[@balamira297]

Crystal clear ji! Dhanyawad 🙏

[@Innozant]

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

[@shashankku.1469]

awesome example and explanation too!

[@rafatali6058]

So wonderful method sir
Thank you so much

[@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

[@Knowledge-wf2vw]

You are different from others ... Great master

[@Innozant]

Thanks Ankit.Really means a lot that me

[@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

[@Sunset.k79]

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

[@Innozant]

Thanks Jhaji..Keep Learning ♥️

[@shivamkr3030]

Wow sir I am your big fan outstanding

[@dssaini689]

Wonderful sir, a unique way to reaching

[@Innozant]

Thanks ❤️

[@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.🙏❤️🙂

[@ManojSingh-wt9de]

Excellent explain

[@reshmanikam5992]

Fantastic sir 👌👍

[@udaykakde4595]

You are great sir

[@paulpal6599]

Sir aapki teaching style amazing..love you sir

[@Innozant]

Thanks 👍❤️

[@zahoorsarbandi2982]

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

[@Innozant]

Thanks Zahoor sahab.🙏❤️

[@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.

[@AhmedKhan-ql2oy]

Superb Sir., Superb explain

[@Innozant]

Thanks Khan sahab

[@jitenkalam6679]

Fantastic 🎉❤

[@raghavkumar5042]

Thank You Bro🙂

[@Unfiltered_ind]

Sir u r my favourite teacher in excel ...

[@Innozant]

Thanks dear

[@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

[@RushiShah2007]

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

[@Innozant]

👍

[@Adeeluddin06]

Informative.

[@lifeignite2048]

Thank You so much

[@WST16]

Nice. Thank you

[@mdsani743]

Thank you sir

[@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

[@shrikantbadge3978]

THANK YOU!

[@focuspower2374]

Awesome 👍😎

[@kinghundred]

very great sir

[@ankitsinghel1116]

Great👍

[@rakshitkumar2330]

Mind blowing 🤯

[@Innozant]

Thanks

[@malcolmdevadas5903]

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

[@Innozant]

Thanks dear.Keep learning

[@ajitraj51]

Mind blowing sir want mores....

[@Innozant]

Thanks Ajit ji🙏❤️

[@perfectlover9918]

Superb

[@exceltech6012]

Very nice sir

[@sonukumar-xp5sd]

Awesome 😆

[@kelkarsm]

Wonderful

[@nirmalrana9439]

Bahut badhiya

[@VimalKumar-ih6ik]

Awsome😊

[@Shradpatil02]

Awesome sir 👍✅

[@Innozant]

Thanks Ganesh Ji

[@narinderkumar7831]

bahut badiya

[@karankapoor200]

👌🏻👌🏻👌🏻 super video

[@shashanksingh5170]

Excellent 👍

[@Innozant]

Thanks Shashank

[@durgeshpratap5019]

Super grate Sir

[@ankitsinghel1116]

Nice video sir

[@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 🙏👍🧡

[@Rejuanhaque]

Excellent Sir

[@Innozant]

Thanks ❤️

[@badripatra2504]

superb

[@PUJARI16]

Super 👌

[@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 😘😘

[@shurawat8650]

gazab sirrr

[@aanjalisurve4962]

Superb sir

[@Innozant]

Thanks Anjali

[@rahulrakshe1988]

Nice bro

[@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

[@tayyabyarkhan1048]

❤❤❤ owsummmm

[@rajendardhar]

Thanks.

[@Innozant]

Thanks Rajender ji

[@anandmansoresong9091]

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

[@Innozant]

Thanks Dear

[@meditationmusic6482]

So nice Sir.

[@Innozant]

Thanks Sanoj

[@asdagar9633]

Nyc Sir ji

[@tarakmistry2748]

wonderful

[@Innozant]

Thanks Tarak.. Happy learning ❤️

[@sanakhan9169]

THANKS SIR

[@Innozant]

Thanks Sarita

[@imranibrahim8247]

Outstanding

[@Innozant]

Thanks dear👍❤️

[@user-ys2xf1yu7h]

Nice

[@atulshukal4072]

Very good Sir

[@Innozant]

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

[@soniyaunni1975]

Nice video and with funny explanation...

[@Innozant]

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

[@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

[@AdityaKumar-lq7nj]

Very nice

[@Innozant]

Thanks Aditya

[@vinothkumarmanoharan2317]

I want to see all the videos and learn..

[@ShivamKumar-sb4le]

Super sir

[@Innozant]

Thanks Shivam

[@nityasharma5923]

Fabulous videos🤩

[@Innozant]

Thanks Sharmaji for your appreciation.Keep wathing and share .

[@nityasharma5923]

@@Innozant u wlcm jha jii

[@sarvodayaconventvidisha1757]

Super

[@Innozant]

❤️👍

[@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.

[@mamalik1088]

Super say upper

[@Innozant]

Thanks Malik Sahab

[@naeemulhassan1426]

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

[@rinturoy8014]

I am gradually becoming an expert in Excel

[@mohdirfankhan7743]

Sir, If we make ID alpha numeric, will it work or not..? please guide

[@koushik4484]

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

[@Innozant]

Really means a lot to me..Keep exploring 😊

[@anilrajput6497]

You are a genius sir. Hatss offff🙏🙏🙏

[@Innozant]

Thanks Anil ji❤️

[@gauravbhatia7987]

Good

[@Innozant]

🙏👍

[@ubaidillahmuhammad20]

i like it

[@Innozant]

Thanks for showing interest in our video and you learn from there,Surely send you the practice file for other video soon.

[@amitapattanaik1071]

Excelent

[@Innozant]

Thanks Salil.

[@vedsingh6777]

Please make a video on XIRR and IRR formula

[@Innozant]

👍❤️

[@suvajitkar6951]

we can use match function also

[@loved787]

Sir please excel full videos banaiye

[@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

[@zohaibsiddiqui5857]

❤️

[@mohdsamiulrahman4453]

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

[@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.

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

[@mickymishra]

Sir, thank you for this easy teaching skills. I have a question. I want to last record from any data with reference to other column. Is it possible. For example I have a data in col A and another data in col D. Data of col A is unique but Data of col D may repeat or different and i want to extract last record from it. Please help. 🙏🙏