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

[@RMKserve]

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

[@Innozant]

Thanks for your appreciation dear

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

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

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

[@tapa671]

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

[@Unfiltered_ind]

Sir u r my favourite teacher in excel ...

[@Innozant]

Thanks dear

[@zahoorsarbandi2982]

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

[@Innozant]

Thanks Zahoor sahab.🙏❤️

[@malcolmdevadas5903]

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

[@Innozant]

Thanks dear.Keep learning

[@paulpal6599]

Sir aapki teaching style amazing..love you sir

[@Innozant]

Thanks 👍❤️

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

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

[@rashidiqbal7547]

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

[@Knowledge-wf2vw]

You are different from others ... Great master

[@Innozant]

Thanks Ankit.Really means a lot that me

[@shivamkr3030]

Wow sir I am your big fan outstanding

[@Rameshkumar4567]

Excellent combination Sir. Thank you

[@VikasSingh-em3ol]

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

[@RushiShah2007]

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

[@Innozant]

👍

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

[@AhmedKhan-ql2oy]

Superb Sir., Superb explain

[@Innozant]

Thanks Khan sahab

[@anandmansoresong9091]

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

[@Innozant]

Thanks Dear

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

[@rafatali6058]

So wonderful method sir
Thank you so much

[@jitenkalam6679]

Fantastic 🎉❤

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

[@reshmanikam5992]

Fantastic sir 👌👍

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

[@dssaini689]

Wonderful sir, a unique way to reaching

[@Innozant]

Thanks ❤️

[@rakshitkumar2330]

Mind blowing 🤯

[@Innozant]

Thanks

[@shashankku.1469]

awesome example and explanation too!

[@Sunset.k79]

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

[@Innozant]

Thanks Jhaji..Keep Learning ♥️

[@jyotijha7910]

Wow sir.. amazing explanation..

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

[@ajitraj51]

Mind blowing sir want mores....

[@Innozant]

Thanks Ajit ji🙏❤️

[@tayyabyarkhan1048]

❤❤❤ owsummmm

[@asdagar9633]

Nyc Sir ji

[@karankapoor200]

👌🏻👌🏻👌🏻 super video

[@ganesh.mali02]

Awesome sir 👍✅

[@Innozant]

Thanks Ganesh Ji

[@ManojSingh-wt9de]

Excellent explain

[@udaykakde4595]

You are great sir

[@raghavkumar5042]

Thank You Bro🙂

[@soniyaunni1975]

Nice video and with funny explanation...

[@Innozant]

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

[@rinturoy8014]

I am gradually becoming an expert in Excel

[@VimalKumar-ih6ik]

Awsome😊

[@Adeeluddin06]

Informative.

[@sonukumar-xp5sd]

Awesome 😆

[@anilrajput6497]

You are a genius sir. Hatss offff🙏🙏🙏

[@Innozant]

Thanks Anil ji❤️

[@nityasharma5923]

Fabulous videos🤩

[@Innozant]

Thanks Sharmaji for your appreciation.Keep wathing and share .

[@nityasharma5923]

@@Innozant u wlcm jha jii

[@meditationmusic6482]

So nice Sir.

[@Innozant]

Thanks Sanoj

[@prolaypaul5542]

Great sir

[@Rejuanhaque]

Excellent Sir

[@Innozant]

Thanks ❤️

[@nirmalrana9439]

Bahut badhiya

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

[@ankitsinghel1116]

Great👍

[@narinderkumar7831]

bahut badiya

[@durgeshpratap5019]

Super grate Sir

[@aanjalisurve4962]

Superb sir

[@Innozant]

Thanks Anjali

[@ankitsinghel1116]

Nice video sir

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

[@shashanksingh5170]

Excellent 👍

[@Innozant]

Thanks Shashank

[@WST16]

Nice. Thank you

[@shurawat8650]

gazab sirrr

[@kinghundred]

very great sir

[@lifeignite2048]

Thank You so much

[@badripatra19]

superb

[@PUJARI16]

Super 👌

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

[@imranibrahim8247]

Outstanding

[@Innozant]

Thanks dear👍❤️

[@vinothkumarmanoharan2317]

I want to see all the videos and learn..

[@suvajitkar6951]

we can use match function also

[@koushik4484]

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

[@Innozant]

Really means a lot to me..Keep exploring 😊

[@atulshukal4072]

Very good Sir

[@Innozant]

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

[@mdsani743]

Thank you sir

[@rahulrakshe1988]

Nice bro

[@perfectlover9918]

Superb

[@eshaniist]

Sir @Innozant ritupriya arora 2nd example is missing i cannot find it anywhere., could you please reply as I am learning now only with your videos.

[@AdityaKumar-lq7nj]

Very nice

[@Innozant]

Thanks Aditya

[@ShivamKumar-sb4le]

Super sir

[@Innozant]

Thanks Shivam

[@bhavyadudeja5969]

Wonderful

[@mohdsamiulrahman4453]

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

[@mamalik1088]

Super say upper

[@Innozant]

Thanks Malik Sahab

[@sayantankesh5767]

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

[@MohanKumar-uk1gj]

Hi I have a question if text in the cells are duplicate meaning same names with different I'd then how which name it will pick

[@Innozant]

which comes first..in case of duplicate vlookup we need to pass countif to get duplicate value then proceed with vlookup

[@MohanKumar-uk1gj]

@@Innozant great can u give us example pls in this challenge pls

[@MohanKumar-uk1gj]

Agar app ek example video pe dekha de to behatar hoga samjanekiliye..thank you

[@MohanKumar-uk1gj]

Manlijiye rishab Gupta name I'd 2356 dusura name rishab Gupta I'd 89012 agar mere ko rishab 89012 value chahiye name se mutabik to yen function kaise mere ko madat karogi pls explain in video

[@MohanKumar-uk1gj]

Rishab Gupta duseri row pe ho to

[@MdFaruk-z6u6e]

Nice

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

[@sanakhan9169]

THANKS SIR

[@Innozant]

Thanks Sarita

[@sarvodayaconventvidisha1757]

Super

[@Innozant]

❤️👍

[@shrikantbadge3978]

THANK YOU!

[@rajendardhar]

Thanks.

[@Innozant]

Thanks Rajender ji

[@safdarayaz3030]

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

[@ansh312]

Bhai ek problem solve karwa do.. ek column mai date and time hai dd/mm/yyyy hh:mm format mai .. mujhe doosre column mai text chahiye.. jaise agar iss column mai data i 1/11/2021 07:00 toh return value Apac aaye.. maine vlookup use kiya hai but wo time pe kaam kar raha hai lekin date and time ek saath hai toh fail ho raha hai.. 🙏🏼

[@Innozant]

Kais euse koye hai .Kindly show your formula

[@sunilmahawar362]

Sir ek file h jisme IF ka use kr kuch codding ki gayee h jo mere system m to bilkul thik h pr other system m shear kr reha hu naa to us #NAME? aa reha h plz ser solved this problm

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

[@mohdirfankhan7743]

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

[@meshkaturrahman4375]

Please tell me, what you press in vlook up after D4, for that it shows dollar signs.

[@Innozant]

F4 dear ..watch cell/formula reference from playlist basic excel dear

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

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

[@gauravbhatia7987]

Good

[@Innozant]

🙏👍

[@tarakmistry2748]

wonderful

[@Innozant]

Thanks Tarak.. Happy learning ❤️