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.
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 ?
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
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????
@@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..
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.
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
Hello , really appreciate your hard work and the way you explained thetopics....provide nextered Vlook up tutorial as well.
Glad you liked ✅️ n noted ✅️
Sir iska short cut hai Ctrl + Shift + V aur baad me V to remove values
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.
Glad it was helpful ✅️
Thank you so much sir
Glad you liked ✅️
Thanks bhai..
Cristal Clear sir
Bhaiya agr mera vlookup me jab duplicate name hai agr hume pehle ka value nahi chahiye dusre ka chahiye toh usse kaise nikalenge ?
Sort the lookup column values and then apply for vlookup
@@RishabhMishraOfficialcan you explain in detail bro ?
Hi
Itna difficult hai😢
Bhot asaan hai yrr
Where is EDA video???
Thank you sir... For clearing the Vlookup formula..
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 ?
Very last ctr C I tried but couldn't get the results as u showed
Bhai mein FN+F4 dabata hu to keyboard ka light on ho jata hai 🥲
Just try f4. Else use dollor symbol manually
Nahi ho raha hai...N/A ya value aa raha hai
ThankYou
thank you very much , you were very clear in the explanation !!!
what about xlookup and if , ifs , sum , sum ,sumif , sumifs
Check full excel course on this channel
best vlookup tutorial so far, easy, on point, mentioned pros and cons, all sorted. Great video Rishabh.
Glad you liked it! ✅️
Sir ye function plus f4 samjh nahi aaya mujhe
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
@@RishabhMishraOfficial hello sir..you haven't told about index, match, if, count if,sum if etc etc
Ty ❤
Ek number.. waiting for more tutorial
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????
NO
Can we deal with duplicates in vlookup formula?
You have not talked about index, match, if , count if etc etc formulas...
This video is only for vlookup, to learn other topics you need to watch excel tutorial video on this channel
@@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..
@@RishabhMishraOfficial plzz answer...
Duplicate value ke liy kya krna bataya ni thoda lamba video banay
thank you
i have one query sir can we export the power bi report in the excel completely or just by visual
Yes you can export tables n data but not the complete report as it is
What if name is reapeting
In that case concatenate two or more values that are common in both tables and make a unique id then do vlookup
Thank You Sir
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?
Vlookup ke 3rd criteria mein phirise vlookup karo
Fn+f4 se volume aa rha
fn + esc press karo phele fir fn + f4 press karna
Thank you Sir
Bhaiya how we konw that table is not fixed?
thank you sir
Thank u sir
sir function button pe fn press kana hai bas
Good tutorial.... It help me a lot 😊
Glad it helped ✅️
Thank you so much...
Glad you liked it ✅️
bhai isme dublicate cell red ho jate h ye normal kse hoge badme?
Again tap on "condition format" and click on clear rules, then click on clear all rules.
Happy birthday mer jn 🎉
Attitude 😮
Function+f4 me function kya h??
function key in Keyboard -Fn
Where can I find fn??
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.
Video more than blur hai
Change the video quality settings 🤦♂️