Excel VLookup Formula in 8 Minutes [VLookup in Excel]

Register now for the webinar - bit.ly/3KPBiNq
A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one.
FALSE searches for the exact value in the first column.
Multiple Worksheet interconnected VLOOKUP()
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We covered the following topics:
00:00 Introduction to Vlookup in Excel
00:14 Interworksheet VLookup in Excel
00:58 How to use Interworksheet VLookup in Excel
08:01 How to use Text to Number in Excel
A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one.
FALSE searches for the exact value in the first column.
Multiple Worksheet interconnected VLOOKUP()
Double vlookup in Excel
Excel VLOOKUP Formula with Multiple sheets | Vlookup in Excel in Hindi
To watch more videos visit: www.excelsuperstar.org/
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

Пікірлер: 912

  • @ExcelSuperstar
    @ExcelSuperstar3 жыл бұрын

    Click here for Excel Basic to Pro Course: bit.ly/34GhsCM

  • @Tyagi423

    @Tyagi423

    11 ай бұрын

    Hi

  • @BCCDAILYPAK
    @BCCDAILYPAK2 жыл бұрын

    Ya ALLAH har insan kamyab ho har insan ko sehat izat or kamyabi ata farma tohi Malik hay meray mola tohi hay bus.

  • @vikascharan4869

    @vikascharan4869

    2 жыл бұрын

    kya bakwas kar raha hai

  • @aryan_proud_kafir

    @aryan_proud_kafir

    2 жыл бұрын

    stop your non-sense bullshit

  • @arfanali6375

    @arfanali6375

    2 жыл бұрын

    Ameen sumameen

  • @faizancielo

    @faizancielo

    2 жыл бұрын

    Ameen 😇 🤗

  • @parveenkumar-is3km

    @parveenkumar-is3km

    2 жыл бұрын

    Allah se mangna band kro. Khud koshish kro insano ke bhle ke liye.

  • @cuteindiangirl--ishu9077
    @cuteindiangirl--ishu90775 жыл бұрын

    Thanks for the knowledge of Vlook up. The way u teach is fantastic.

  • @simpleexcelexamples9619
    @simpleexcelexamples96192 жыл бұрын

    Great video, great content, just simple and to the point, great voice to listen too: THANK YOU 😊

  • @zakeermohamedkhan8750
    @zakeermohamedkhan87506 жыл бұрын

    Beautiful sportive presentation. This makes "Learning is Fun"

  • @vikashthapa3023
    @vikashthapa30234 жыл бұрын

    3:56 the way you give confidence to us sir is excellent,by the way I'm your new subscriber and student.

  • @oluwaseyialao1146
    @oluwaseyialao11465 жыл бұрын

    why would anyone give this a thumbs down? Really good job and thanks for providing the accompanying excel files to practise with.

  • @bubblegum6701

    @bubblegum6701

    3 жыл бұрын

    The title is in English and the video is not

  • @varundas9723

    @varundas9723

    3 жыл бұрын

    I GUESS FANS OF CARDI B😂

  • @Paji_Vlogger

    @Paji_Vlogger

    3 жыл бұрын

    Samaj aara ha kya tuje..jo gyaan baat rha😂

  • @harshitrastogi1820

    @harshitrastogi1820

    2 жыл бұрын

    Do you know hindi

  • @aryan_proud_kafir

    @aryan_proud_kafir

    2 жыл бұрын

    @@bubblegum6701 you haven’t read the whole title, vlookup in Hindi

  • @pawansriraam9890
    @pawansriraam98905 жыл бұрын

    Am in love with Ur explaination, beautifully explained sir, thank you so much........

  • @Rakeshkumar-cr2go
    @Rakeshkumar-cr2go2 жыл бұрын

    Kya samjhaya hai sir. Salute🙋 Kaash aap mere teacher hote, aap jaise teacher kismat walo ko milte hai.

  • @pavithrashettigar6099
    @pavithrashettigar60994 жыл бұрын

    Woww just love the way you explain !!! Amazingg

  • @diwakarsingh8328
    @diwakarsingh83285 жыл бұрын

    Good explanation,, felt like hearing cricket commentary.... which created more interest to watch this video.

  • @1974manna
    @1974manna5 жыл бұрын

    The way you explain things is just awesome, you got lovely voice. God bless you.

  • @LoneWolf-yp9qw
    @LoneWolf-yp9qw4 жыл бұрын

    Thank you brother. Your way of presentation and diction is amazing. Keep up the good work!

  • @kashish9285
    @kashish92855 жыл бұрын

    I loved the way you explained this! So patiently, step by step! keep it up :)

  • @ExcelSuperstar

    @ExcelSuperstar

    5 жыл бұрын

    Keep going Kashish Sharma 👍

  • @SanaKhan-zd3rp

    @SanaKhan-zd3rp

    2 жыл бұрын

    @@ExcelSuperstar Hello Sir, I'm pressing F4, but the dollar sign is not available.. what should I do now.

  • @alaudinjami6936

    @alaudinjami6936

    2 жыл бұрын

    @@SanaKhan-zd3rp press Shift+4 (numeric 4 key)

  • @raginichauhan6862
    @raginichauhan68626 жыл бұрын

    Thanks sir... And your voice is awesome 🌟 🌟

  • @sachinvitukade2440
    @sachinvitukade24405 жыл бұрын

    Superb, got right solution here. Good explanation skill, Thank you Sir

  • @mukeshtiwari8468
    @mukeshtiwari84685 жыл бұрын

    I was here for a vlookup refresher course, need to use it after 11 years in my job. And your video and voice is so good that loved it.

  • @antu4581
    @antu45816 жыл бұрын

    Absolutely, no words, thanks from Bangladesh

  • @ANOOPS70

    @ANOOPS70

    6 жыл бұрын

    sadiqur rahman kzread.info

  • @rajatareq
    @rajatareq7 жыл бұрын

    Great.......... thank you Dost :)

  • @arijeetkumarsharma226
    @arijeetkumarsharma2265 жыл бұрын

    Superb video for beginners. Thanks a lot.

  • @jibrankhan8546
    @jibrankhan8546 Жыл бұрын

    solved my problem after browsing videos for 3-4 hours - Crisp and Clear - thanks

  • @GauravPaul
    @GauravPaul5 жыл бұрын

    Bhai I think you also dub for Hollywood movies😀.Voice clarity is amazing

  • @jublidas4771
    @jublidas47716 жыл бұрын

    Very helpful video... 👍

  • @jitendrabchaudhary3106

    @jitendrabchaudhary3106

    5 жыл бұрын

    Only for beginner

  • @RaviRajput-ki8sz
    @RaviRajput-ki8sz5 жыл бұрын

    Amazing Voice explations. Thanks you so much and god bless you brother.

  • @vipinpandey9761
    @vipinpandey97615 жыл бұрын

    Just after watching I've subscribed your Chanel sir,amazing style of teaching.

  • @ManishKumar-om2wf
    @ManishKumar-om2wf6 жыл бұрын

    do din se dimag khrab kr raha tha smjh me nahi aa raha tha . aapke smjhate hi smjh aa gya. thank u sooo much sir

  • @ExcelSuperstar

    @ExcelSuperstar

    6 жыл бұрын

    Thank u Manish

  • @ManishKumar-om2wf

    @ManishKumar-om2wf

    6 жыл бұрын

    Excel Superstar welcm sir

  • @anjusharma7179
    @anjusharma71797 жыл бұрын

    best teacher

  • @poonamkaushik3574

    @poonamkaushik3574

    7 жыл бұрын

    agree

  • @JayPrakash-baghel

    @JayPrakash-baghel

    6 жыл бұрын

    Nice video sir It is very very nice

  • @jayantiborgaohain9518

    @jayantiborgaohain9518

    6 жыл бұрын

    +Jayanti Borgaohain hpkkk

  • @jayantiborgaohain9518

    @jayantiborgaohain9518

    6 жыл бұрын

    +Jayanti Borgaohain hih$&dh$&$&&&$&$*#$&^fhfh$$h$&fj$rhj$j%&$&fr*&&d

  • @afzalahsan20

    @afzalahsan20

    5 жыл бұрын

    aap study ki ho to mujhe bhi learn kra do yaar 9304371455

  • @surajbala6107
    @surajbala61075 жыл бұрын

    very good job. i liked the way you explaining it. so nicely you respecting each and every words, text, formula , function. its like it all has life. loved it. last but not least , u got very good voice with humble way of presenting it. i can see your true nature and a very polite and good personality in you. Rounds of applause for you.

  • @goatsk
    @goatsk Жыл бұрын

    You are a legend for corporate people. Thank you brother don't stop making such videos they are very helpful.

  • @anujchauhan3013
    @anujchauhan30136 жыл бұрын

    Great sir lagta hai aap salman khan ke faan hai

  • @ExcelSuperstar

    @ExcelSuperstar

    6 жыл бұрын

    Right Anuj Chauhan #Race3

  • @himanshusharma-iu6bf

    @himanshusharma-iu6bf

    5 жыл бұрын

    Kaise bey?

  • @Chauhankd94

    @Chauhankd94

    5 жыл бұрын

    मुल्ले के फैन से कुछ नही होता अनुज भाई अपने भाई की जुबान पर तो सरस्वती माँ विराजमान है बस...⛳️ 😍

  • @vizergaming961
    @vizergaming961 Жыл бұрын

    Sir aap k jesa genuine video koi nahi banata .... Thnks a lot

  • @amirzia2415
    @amirzia24155 жыл бұрын

    Xlent, i hv done this in 2006 while i was supervisor in Tathya dotcom, since den i forget, now i revised and got d answar, txns

  • @subhankarbhattacharya369
    @subhankarbhattacharya3695 жыл бұрын

    The way u r talking... just amazed me.... presentation was awesome....and voice... just Excel-ent...

  • @daljeetsian
    @daljeetsian4 жыл бұрын

    Nicely explained buddy... With core examples.. Keep it up & teach everyone by making new videos.

  • @bsyenterprises7057
    @bsyenterprises70576 жыл бұрын

    Wonder Full Explanation, Very Very Thank You for such Brilliant Efforts Keep it Up SIR.

  • @raveenakumari8960
    @raveenakumari89605 жыл бұрын

    Amazing video sir...nd Ur teaching method is fabulous.. it's really working!!"thanku so much"

  • @hardikdave3776
    @hardikdave37764 жыл бұрын

    you are megician... the way you teaching is awesome..... fun with learn...great man

  • @esteticorakesh8128
    @esteticorakesh81282 жыл бұрын

    The way you've taught, was fantastic!!!!❤️❤️❤️❤️

  • @seemadamkondwar4899
    @seemadamkondwar48995 жыл бұрын

    Thx a lot sir, I like so much your teaching method & also good teaching skills to understand front of candidate.

  • @mohdsohail1126
    @mohdsohail11266 жыл бұрын

    You r truly immensely good the way your explanation....this is it

  • @ANKURGOVIND
    @ANKURGOVIND5 жыл бұрын

    VLOOK UP IS A GREAT TOOL TO DO HOUR OF WORK IN SECONDS. THANKS FOR YOUR TUTORIAL VIDEO

  • @sark0077
    @sark00773 жыл бұрын

    Sir mesmerized by your teaching, loved it all through, and don't forgot to subscribe you. Thank u sir, to made my job easy.

  • @syedsabzwari5847
    @syedsabzwari58475 жыл бұрын

    Bro....your way of teaching is awesome!

  • @deepamishra3296
    @deepamishra32965 жыл бұрын

    Amazing Video. Wouldn't have learnt easier than this!

  • @Jesuslovesyou.7808
    @Jesuslovesyou.78086 жыл бұрын

    What a voice and what a way of teaching... Thanks Sir

  • @maneeshkumarsinghai1077
    @maneeshkumarsinghai10776 жыл бұрын

    बहुत ही शानदार वीडियो एवं आपका तरीका भी उससे ज्यादा शानदार है। आप सच में एक अच्छे टीचर है।

  • @sajanmalviya9262
    @sajanmalviya92626 жыл бұрын

    thanks for such teaching very very help full for those who dont have time to go to any coaching centre n all

  • @superkings2.057
    @superkings2.0574 жыл бұрын

    After long time I have learned vlookup formula which I have forgot the formula before thanks a lot its a very good method of teaching......

  • @Awakenbeing
    @Awakenbeing5 жыл бұрын

    very nicely explained, I will recommend this channel for excel tutorial to my friends.

  • @ghKk736
    @ghKk7366 жыл бұрын

    Best, best , best dear, good Communication way, i appreciate you..

  • @MuhammadZubair-dm1fb
    @MuhammadZubair-dm1fb5 жыл бұрын

    Yar aj apki video dekhi he Ap k samjhane ka andaaz bra dhansoo he Lo subscribe bhi kr diya Bell icon bhi press ker diya Now waiting for your next video Superbbbb bro !!!!

  • @BLACK-hl4ic
    @BLACK-hl4ic6 жыл бұрын

    Good initiative, Keep it up, I am use many time, 👍👍👍👍👍👍

  • @sanaokarian6169
    @sanaokarian61693 жыл бұрын

    ahaaaa...bohat umda tareeqa pehli baar maza aa gaya samajh ker ... Excellent..love from Pak....

  • @priyakaler3884
    @priyakaler38845 жыл бұрын

    Way of teaching and explaining is sooo good even more interesting.

  • @sudhirtulankar5865
    @sudhirtulankar58654 жыл бұрын

    आपके समझाने का तरीका अच्छा लगा।। मुझे इससे मदत मिलेगी, धन्यवाद!!

  • @9595364544
    @95953645446 жыл бұрын

    Bohat hi khoobsurat andaaz hai samjhane ka. Awesome bro👌👌

  • @maghaffar3924
    @maghaffar39242 жыл бұрын

    Aap bohot hi lajawab ho sir Hats off to U 😇 Itna Aram se maine kisi ko nahi dekha samjhate hue Lv from Hyderabad ❤️

  • @asadullahmunir6500
    @asadullahmunir65005 жыл бұрын

    Best trick to teach. you are the best teacher. Best video for ever I watched for Vlookup.

  • @MDARSHAD-pc3qz
    @MDARSHAD-pc3qz2 жыл бұрын

    Love you Rishab the way you are explaining in video’s it’s every clear and I Learn a lots. Thanku ❤️😊

  • @Shshashshshshshsh
    @Shshashshshshshsh5 жыл бұрын

    Nice tone and clear dialog delivery along with superb attitudes

  • @vinashkary22
    @vinashkary225 жыл бұрын

    Very sweet voice you have and i like your frank interaction with us...Good job very sweet tutorial.

  • @jaykantariya2403
    @jaykantariya24035 жыл бұрын

    Thanks sir you are super talented superstar incredible lovely voice like voice artist , creative teacher ever with detailed explanation...a lot thanks

  • @asadullahmunir6500
    @asadullahmunir65005 жыл бұрын

    I have done this first time. you are the best of All. thanks a lot.

  • @mahis9260
    @mahis9260 Жыл бұрын

    thank you sir,,,, super tutorial i forget vlookup formula and i searched so many video but finaly your video very helpful to me ,,, thank you once again

  • @MuhammadAther
    @MuhammadAther6 жыл бұрын

    Wonderful teaching style and lecture. Covered all the necessary lessons to taught.

  • @ANOOPS70

    @ANOOPS70

    6 жыл бұрын

    kzread.info

  • @vks6696
    @vks66964 жыл бұрын

    Thanx a lot for teaching in such an interesting manner.....A novice like me too got it...

  • @zishanmohd3749
    @zishanmohd37495 жыл бұрын

    Wow Sir apke pdhane ka style bhutttt achcha hai I like it 😘😘😘😘😘

  • @unteck7023
    @unteck70234 жыл бұрын

    sikhane ka tarika 1 no., problem ke sath solution bhi..nice

  • @mansoorsiddiq4728
    @mansoorsiddiq47285 жыл бұрын

    Aap k samjhaney ka tareeka bohat simple or effective hai thanks

  • @raniras8850
    @raniras88503 жыл бұрын

    Fantastic Sir.=VLOOKUP(cell number of the reference,feels of the lookup cells + F4,the cell of the looked up item,0 or 1(0))

  • @telljansiddiqi
    @telljansiddiqi4 жыл бұрын

    Amazing teaching methods THANK YOU

  • @chiragkapoor373
    @chiragkapoor3735 жыл бұрын

    Very helpful, Also explained greatly what not to do, which can lead to error

  • @ajayexoad702
    @ajayexoad7024 жыл бұрын

    Thank you, it helped me save a lot of time.

  • @TheRosh71
    @TheRosh716 жыл бұрын

    Bohot hi sahi tarike se smjhaya h sir ...👌👌

  • @xmenmedia4918
    @xmenmedia49185 жыл бұрын

    bhai voice quality bohot achchi hai uske sath samjhane k style bhi easy hai or sabse achchi baat samjhane k style bohot dostana hai na ki teacharana.

  • @vivekgoswami9009
    @vivekgoswami90096 жыл бұрын

    Way of spoken and enthusiasm level is attractive. 👌👌👌👌👌👌👌👌👌👌👌👌👌👌Great Sir

  • @xunairaramzan8451
    @xunairaramzan84512 жыл бұрын

    His way of teaching is excellent.....impressive

  • @arrry100
    @arrry1006 жыл бұрын

    Superb Dost.. what a simple and amazing way you explained this... Kudos !!

  • @ExcelSuperstar

    @ExcelSuperstar

    6 жыл бұрын

    Thanks, Puneet Sharma Keep Watching our latest Tutorials

  • @bhagwaticharanverma3684
    @bhagwaticharanverma36845 жыл бұрын

    Thanks a lot for helping us with this knowledge... :)

  • @lakshmandas2976
    @lakshmandas29764 жыл бұрын

    The way of explanation is great 😘😗 Please help us with more more videos . Thank u sooooooo much 😘😘😗😗

  • @thedewprogrammerusmani8872
    @thedewprogrammerusmani88726 жыл бұрын

    Best se bhi best teacher 👏👏way of teaching is really amazing very good 👍

  • @prathameshkashte2289
    @prathameshkashte22895 жыл бұрын

    Sir aap bohot achhi tarah se samjate he. Thank u sir for teaching vlookup.

  • @xeeclassic
    @xeeclassic6 жыл бұрын

    very intriguing..GOD BLESS YOU

  • @premiericon2023
    @premiericon20233 жыл бұрын

    GOOD DAY.. SIR YOU ARE BRILLIANT.... I HAVE LEARNED SO MUCH FROM YOUR VIDEOS. I AM ALSO AN I.T INSTRUCTOR IN AN INSTITUTE AND TRY MY BEST TO TEACH LIKE YOU. LOTS OF RESPECT & REGARDS FOR YOU.. REGARDS, NAVEED ALAM FROM KARACHIU, PAKISTAN

  • @abhaymote2993
    @abhaymote29934 жыл бұрын

    Thank you... You just saved my 2 days of work...😊

  • @Amritanjan_01
    @Amritanjan_015 жыл бұрын

    Thanks for uploading this video love you

  • @organickitchen.6127
    @organickitchen.61276 жыл бұрын

    Nice one. I was little bit confuse in vlookup but now all cleared.

  • @bawramann1590
    @bawramann15902 жыл бұрын

    Brother you're a superb teacher... Love and best wishes from Pakistan

  • @techguru3168
    @techguru31686 жыл бұрын

    अन्दाज। पसन्द आया दोस्त . बहुत ही अच्छा समझाने का तरीका।

  • @azizshaikh3715
    @azizshaikh37152 жыл бұрын

    You made it so simple to understand, thank you Sir ji..

  • @_KAnil
    @_KAnil4 жыл бұрын

    Super vedios, your tricks really helping to improve performance

  • @shankiewalia1184
    @shankiewalia11845 жыл бұрын

    Thnx sir aap bahut achha smjhate ho aaj finally clear ho hi gya vlookup formula

  • @nileshtiwari736
    @nileshtiwari7364 жыл бұрын

    Your way of teaching is awsome...👍 Aaj tak koi mujhe itne acche se samjha paya he , akhir me mene sikh he liya..😅🤣

  • @princesj5526
    @princesj55262 жыл бұрын

    You are Great!! I like the way you explained this.

  • @aqeelahmed9928
    @aqeelahmed99285 жыл бұрын

    Superb tutorial.. very easy way of teaching

  • @rohitmishra041
    @rohitmishra0414 жыл бұрын

    Superb beautifully explained thanks a lot for helping ...🙏

  • @GhulamAbbas-el4pb
    @GhulamAbbas-el4pb5 жыл бұрын

    You are amazing man - fun to watch and learn

  • @VijayVerma-co4ec
    @VijayVerma-co4ec6 жыл бұрын

    wow aapke samjhane ka tarika bahut accha hai jyada se jyda first time me hi samjh aa gya

  • @vishalchouhan7350
    @vishalchouhan7350 Жыл бұрын

    I have never seen the concept you teach , you are the best ever

  • @KrrishnaParihar
    @KrrishnaParihar6 жыл бұрын

    Thank you so much Sir From MP, India. Very helpful tutorial. But I have some questions to ask you about, One of them is when will we use "IFERROR" before VLOOKUP???

Келесі