How to use VLOOKUP formula in Excel | VLOOKUP in Excel Tutorial

[@gauravbishnoi29]

Thanks a lot sir for sharing this valuable knowledge, issue pehle kaafi Videos dekh chuka hu but clear nahi ho pa raha tha, apki is ek video sara Basic clear kar diya.

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@ashwingogawale5560]

best vlookup tutorial so far, easy, on point, mentioned pros and cons, all sorted. Great video Rishabh.

[@RishabhMishraOfficial]

Glad you liked it! ✅️

[@mrtharunprao]

Thank you sir... For clearing the Vlookup formula..

[@IskconGlobalMovement]

Hello , really appreciate your hard work and the way you explained thetopics....provide nextered Vlook up tutorial as well.

[@RishabhMishraOfficial]

Glad you liked ✅️ n noted ✅️

[@lalittandra7369]

thank you very much , you were very clear in the explanation !!!

[@CORRCTME]

Ek number.. waiting for more tutorial

[@shabbirbagawan7013]

Thank You Sir

[@shilpisinha8567]

Good tutorial.... It help me a lot 😊

[@RishabhMishraOfficial]

Glad it helped ✅️

[@LearnWithRajaniGupta]

Hello Risabh, Clear crystal explaination of vlookup but how to fix the shortcoming of vlookup which you told in case of duplicate datate. how to distinguish and use it ?

[@keshavhotwheelscollection]

Sir iska short cut hai Ctrl + Shift + V aur baad me V to remove values

[@sankalansen8146]

ThankYou

[@muskanshaikh-e1x]

Thank you so much sir

[@RishabhMishraOfficial]

Glad you liked ✅️

[@fazlerabby5570]

thank you sir

[@luckygamerop9346]

Ty ❤

[@mohammadadnanhayat8343]

Thank you so much...

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@prathameshkatke7312]

Thanks bhai..

[@Happinessaroundme]

Sir please answer my one question -------> is data structures and algorithms asked in data analyst interview from freshers????? As a fresher Should I learn data structures and algorithms also for interview????

[@akap1617]

NO

[@DeepakBiswas-f2f]

Cristal Clear sir

[@poojasawarkar2169]

Very last ctr C I tried but couldn't get the results as u showed

[@24_kuldeepkumarmahto24]

Where is EDA video???

[@DataAnalyst4660]

Can we deal with duplicates in vlookup formula?

[@muhammadshoaib-tb2ch]

i have one query sir can we export the power bi report in the excel completely or just by visual

[@RishabhMishraOfficial]

Yes you can export tables n data but not the complete report as it is

[@KaranbeerKaur-qc8cu]

Happy birthday mer jn 🎉

[@KaranbeerKaur-qc8cu]

Attitude 😮

[@AliasgarGheeya]

Hello, How to sort the duplicate issue that you showed in the video? if I need to add multiple names (Duplicate names) how things will work?

[@debanshdash9312]

Vlookup ke 3rd criteria mein phirise vlookup karo

[@SongPreemi]

Bhaiya agr mera vlookup me jab duplicate name hai agr hume pehle ka value nahi chahiye dusre ka chahiye toh usse kaise nikalenge ?

[@RishabhMishraOfficial]

Sort the lookup column values and then apply for vlookup

[@398prathambhardwaj2]

​@@RishabhMishraOfficialcan you explain in detail bro ?

[@raghavgaming9316]

Bhaiya how we konw that table is not fixed?

[@IW-BKL]

f4 fixed q use karte he

[@RishabhMishraOfficial]

If you're using vlookup in the same excel sheet, otherwise it's not required

[@LOKESHKUMAR-iy7cf]

Sir ye function plus f4 samjh nahi aaya mujhe

[@RishabhMishraOfficial]

Hi Lokesh, agar tum vlook same sheet mei use kar rahe ho tho function+f4 ya directly f4 (values fix) karte hai. But agar kisi aur sheet mei vlook use kar rahe ho tho uski koi jarurat nahi hai

[@ZaidAhmad-mu7si]

@@RishabhMishraOfficial hello sir..you haven't told about index, match, if, count if,sum if etc etc

[@noobragaming5805]

what about xlookup and if , ifs , sum , sum ,sumif , sumifs

[@RishabhMishraOfficial]

Check full excel course on this channel

[@aashishsingh2198]

sir function button pe fn press kana hai bas

[@sonammurarkar6197]

Where can I find fn??

[@TrishitSarkar-jn7hw]

Fn is a function lock key on laptops and small size keyboard if you're using a full size keyboard then only F4 can do the work as you don't need a fn key to access the function button.

[@director9951]

Fn+f4 se volume aa rha

[@tejasmahindrakar9596]

fn + esc press karo phele fir fn + f4 press karna

[@srishtikasera7551]

Function+f4 me function kya h??

[@simplysals]

function key in Keyboard -Fn

[@ZaidAhmad-mu7si]

You have not talked about index, match, if , count if etc etc formulas...

[@RishabhMishraOfficial]

This video is only for vlookup, to learn other topics you need to watch excel tutorial video on this channel

[@ZaidAhmad-mu7si]

@@RishabhMishraOfficial that one hour video???in playlist videos you have only talked about v lookup , sum and concatenate functions..but you mentioned rest others in your roadmap pdfs..

[@ZaidAhmad-mu7si]

@@RishabhMishraOfficial plzz answer...

[@palsachdev3496]

Nahi ho raha hai...N/A ya value aa raha hai

[@adityaganeshanverma]

What if name is reapeting

[@RishabhMishraOfficial]

In that case concatenate two or more values that are common in both tables and make a unique id then do vlookup

[@PanditBhaman-k2q]

bhai isme dublicate cell red ho jate h ye normal kse hoge badme?

[@perfectaiprompts]

Again tap on "condition format" and click on clear rules, then click on clear all rules.

[@vishalgaikar1515]

Bhai mein FN+F4 dabata hu to keyboard ka light on ho jata hai 🥲

[@RishabhMishraOfficial]

Just try f4. Else use dollor symbol manually

[@luckmoni]

Duplicate value ke liy kya krna bataya ni thoda lamba video banay

[@ansarinaveed6498]

Hi

[@Kashish_301]

Itna difficult hai😢

[@SantoshKumar-n4p1y]

Video more than blur hai

[@RishabhMishraOfficial]

Change the video quality settings 🤦‍♂️

[@shubhampatidar1814]

thank you

[@MoNiKa-29-RN]

Thank u sir

[@harunmushtaq]

Thank you Sir