Тёмный

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

Rishabh Mishra
Подписаться 269 тыс.
Просмотров 86 тыс.
0% 0

In this video, will learn about VLOOKUP in Excel. What is a VLOOKUP, what is the use of VLOOKUP, how to use VLOOKUP and options in VLOOKUP.
We have taken a sample data to use VLLOKP formula i.e. VLOOKUP example to help you understand the topic in better way.
Topic: How to use VLOOKUP formula in Excel | VLOOKUP in Excel Tutorial
VLLOKUP Practice Data (download link): bit.ly/3PmsWij
Timestamp:
0:00 Intro: VLOOKUP & use
0:39 How to use VLOOKUP formula
2:55 Mistakes in VLOOKUP
4:14 VLOOKUP value
Key keywords: vlookup in excel, vlookup formula in excel, how to use vlookup in hindi, vlookup example, free online excel course
➖➖➖➖➖➖➖➖➖➖➖➖➖
Instagram id: / rishabhnmishra
Linkedin: / rishabhnmishra
Twitter - / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
If you like this video I highly suggest you to check out some other fun videos on this channel 😉
■ How to Become Data Analyst in 2022 | Data Analyst Roadmap
• How to Become Data Ana...
■ Microsoft Excel Tutorial for Beginners - FREE Online Excel Course | Excel Tutorial Part 1
• Microsoft Excel Tutori...
■ Microsoft Excel Tutorial for Beginners - FREE Online Excel Course | Excel Tutorial Part 2
• Microsoft Excel Tutori...
■ Create Pivot Tables In Excel | Use of Pivot Table - Pivot Table Tutorial
• Create Pivot Tables In...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Comment your doubts and queries, so that we can answer them.
SUBSCRIBE to stay tuned to more fun and informative content, consider hitting LIKE button on this video for the sake of RU-vid Algorithm!! Have a great day!
#vlookup #vlookupformula

Опубликовано:

 

29 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@gauravbishnoi29
@gauravbishnoi29 2 месяца назад
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
@RishabhMishraOfficial 2 месяца назад
Glad it was helpful ✅️
@mrtharunprao
@mrtharunprao Год назад
Thank you sir... For clearing the Vlookup formula..
@CORRCTME
@CORRCTME Год назад
Ek number.. waiting for more tutorial
@ashwingogawale5560
@ashwingogawale5560 4 месяца назад
best vlookup tutorial so far, easy, on point, mentioned pros and cons, all sorted. Great video Rishabh.
@RishabhMishraOfficial
@RishabhMishraOfficial 3 месяца назад
Glad you liked it! ✅️
@harunmushtaq
@harunmushtaq 6 месяцев назад
Thank you Sir
@shabbirbagawan7013
@shabbirbagawan7013 2 месяца назад
Thank You Sir
@fazlerabby5570
@fazlerabby5570 9 месяцев назад
thank you sir
@MoNiKa_PanSaRe
@MoNiKa_PanSaRe Год назад
Thank u sir
@LearnWithRajaniGupta
@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 ?
@sankalansen8146
@sankalansen8146 Месяц назад
ThankYou
@IskconGlobalMovement
@IskconGlobalMovement 11 месяцев назад
Hello , really appreciate your hard work and the way you explained thetopics....provide nextered Vlook up tutorial as well.
@RishabhMishraOfficial
@RishabhMishraOfficial 11 месяцев назад
Glad you liked ✅️ n noted ✅️
@shubhampatidar1814
@shubhampatidar1814 Месяц назад
thank you
@shilpisinha8567
@shilpisinha8567 7 месяцев назад
Good tutorial.... It help me a lot 😊
@RishabhMishraOfficial
@RishabhMishraOfficial 7 месяцев назад
Glad it helped ✅️
@mohammadadnanhayat8343
@mohammadadnanhayat8343 Год назад
Thank you so much...
@RishabhMishraOfficial
@RishabhMishraOfficial Год назад
Glad you liked it ✅️
@Thecartoonist_
@Thecartoonist_ Месяц назад
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????
@poojasawarkar2169
@poojasawarkar2169 10 месяцев назад
Very last ctr C I tried but couldn't get the results as u showed
@srkids9167
@srkids9167 Месяц назад
Can we deal with duplicates in vlookup formula?
@aashishsingh2198
@aashishsingh2198 11 месяцев назад
sir function button pe fn press kana hai bas
@user-re1es7pg6m
@user-re1es7pg6m 7 месяцев назад
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
@debanshdash9312 2 месяца назад
Vlookup ke 3rd criteria mein phirise vlookup karo
@raghavgaming9316
@raghavgaming9316 8 месяцев назад
Bhaiya how we konw that table is not fixed?
@24_kuldeepkumarmahto24
@24_kuldeepkumarmahto24 10 месяцев назад
Where is EDA video???
@luckmoni
@luckmoni Месяц назад
Duplicate value ke liy kya krna bataya ni thoda lamba video banay
@SongPreemi
@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
@RishabhMishraOfficial Год назад
Sort the lookup column values and then apply for vlookup
@398prathambhardwaj2
@398prathambhardwaj2 Год назад
​@@RishabhMishraOfficialcan you explain in detail bro ?
@user-zg7gs3ft2l
@user-zg7gs3ft2l 9 месяцев назад
bhai isme dublicate cell red ho jate h ye normal kse hoge badme?
@user-du2wq8gw6h
@user-du2wq8gw6h 4 месяца назад
Again tap on "condition format" and click on clear rules, then click on clear all rules.
@srishtikasera7551
@srishtikasera7551 10 месяцев назад
Function+f4 me function kya h??
@saloniverma3910
@saloniverma3910 8 месяцев назад
function key in Keyboard -Fn
@LOKESHKUMAR-iy7cf
@LOKESHKUMAR-iy7cf Год назад
Sir ye function plus f4 samjh nahi aaya mujhe
@RishabhMishraOfficial
@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
@ZaidAhmad-mu7si 11 месяцев назад
@@RishabhMishraOfficial hello sir..you haven't told about index, match, if, count if,sum if etc etc
@ZaidAhmad-mu7si
@ZaidAhmad-mu7si 11 месяцев назад
You have not talked about index, match, if , count if etc etc formulas...
@RishabhMishraOfficial
@RishabhMishraOfficial 11 месяцев назад
This video is only for vlookup, to learn other topics you need to watch excel tutorial video on this channel
@ZaidAhmad-mu7si
@ZaidAhmad-mu7si 11 месяцев назад
@@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
@ZaidAhmad-mu7si 11 месяцев назад
@@RishabhMishraOfficial plzz answer...
@sonammurarkar6197
@sonammurarkar6197 2 месяца назад
Where can I find fn??
@TrishitSarkar-jn7hw
@TrishitSarkar-jn7hw 21 день назад
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
@director9951 4 месяца назад
Fn+f4 se volume aa rha
@tejasmahindrakar9596
@tejasmahindrakar9596 Месяц назад
fn + esc press karo phele fir fn + f4 press karna
@user-pd5tf4id5v
@user-pd5tf4id5v 2 месяца назад
Video more than blur hai
@RishabhMishraOfficial
@RishabhMishraOfficial 2 месяца назад
Change the video quality settings 🤦‍♂️
@Kashish_301
@Kashish_301 2 месяца назад
Itna difficult hai😢
@Jinu.31
@Jinu.31 Месяц назад
Bhot asaan hai yrr
Далее
How to Use VLOOKUP in Excel (free file included)
15:15
Просмотров 134 тыс.
Excel Vlookup Tutorial - Everything You Need To Know
21:50
VLOOKUP in Excel | Tutorial for Beginners
32:09
Просмотров 1,8 млн
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
7 Ways to Use Vlookup in Excel
16:44
Просмотров 2,7 млн