Unlock the Power of Vlookup : Multiple Values, Criteria & Columns - Excel Magic!

Vlookup Multiple Values - Vlookup Multiple Criteria ! Vlookup Multiple Columns, Vlookup in Excel
In this Excel tutorial I show you how to lookup values from multiple Excel columns. In Excel it's relatively easy to lookup values in one specific columns. But how do you lookup values in multiple columns using just one single formula?
Details of this videos.
00:00 Introduction about VLookup Function
02:05 Multiple Columns Vlookup in Excel
04:32 Vlookup with Match Function (VLOOKUP, Return Multiple Columns Values )
09:26 Vlookup with Iferror function to avoid Errors (vlookup in excel ref error)
Download Practice file :- tynorind-my.sharepoint.com/:x...
Top 5 Examples of XLOOKUP Formula in Excel :- • Do You Know? - What Xl...
How to use VLOOKUP with MATCH Function in Excel:- • How to use VLOOKUP wit...
Beginners to Advance level Series
• (Part-1) Excel Tutoria...
Playlist of Sum Related formulas.
• All Sum Formulas of ex...
Quickly learn how to lookup one value in Excel and return multiple matches. I show practical examples of the VLOOKUP formula.
Tags.
vlookup in excel,vlookup for multiple lookup values,vlookup interview questions and answers,vlookup in excel in hindi,advance vlookup in excel,vlookup multiple values,vlookup multiple criteria,vlookup multiple columns,vlookup multiple matches,vlookup multiple results,vlookup between two worksheets,vlookup advanced excel,vlookup with multiple criteria,vlookup in excel ref error hindi,vlookup function in excel,how to use vlookup in excel,excel vlookup tutorial

Пікірлер: 143

  • @alijockey164
    @alijockey1648 ай бұрын

    This is better than Sequences and column functions

  • @kapilsharma2366
    @kapilsharma236611 ай бұрын

    Waaaah!!! Yhi dhoondh rha tha mai, thankyou!!!

  • @asaduzzamandaria8731
    @asaduzzamandaria873110 ай бұрын

    Nice tricks. Thanks a lot.

  • @RahulSharma-cu4of
    @RahulSharma-cu4of11 ай бұрын

    Thank you so much bro it was really helpful for me.

  • @fazilsaif4851
    @fazilsaif48516 ай бұрын

    Better explained than any other video. 👍👌👏

  • @SurajSingh-ok5pg
    @SurajSingh-ok5pg Жыл бұрын

    Mujhe bahut help mili hai isse ❤❤

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    👍

  • @RahulSharma-cu4of
    @RahulSharma-cu4of11 ай бұрын

    Thank you bro it was really helpful for me

  • @kunalpatil442
    @kunalpatil4429 ай бұрын

    It saved ME hours wow

  • @softwaredynamicsolutions
    @softwaredynamicsolutions9 ай бұрын

    good tutorial, thank you

  • @estordigal8566
    @estordigal85663 ай бұрын

    Seriously thank you 😊

  • @taranjitsingh8516
    @taranjitsingh85169 ай бұрын

    Thank you so much

  • @mostafaeldeeb4134
    @mostafaeldeeb41347 ай бұрын

    انت فشيخ ياض❤

  • @aana12365.
    @aana12365.11 ай бұрын

    Thanks so much

  • @SKLearningJunction

    @SKLearningJunction

    11 ай бұрын

    You're welcome!

  • @shankarshiva2467
    @shankarshiva24679 ай бұрын

    Thanks ❤❤❤

  • @danesmith9262
    @danesmith92629 ай бұрын

    thank you sir

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

    Thank You

  • @arnavaj3392
    @arnavaj339210 ай бұрын

    Ni lga 2016 me. Cntrl shift enter se hoga or vo b only uppar ki ek hi cell niche wali nhi ho rhi

  • @pinkey7415
    @pinkey74157 ай бұрын

    Amezing sir

  • @user-qj4mw2mp9j
    @user-qj4mw2mp9j6 ай бұрын

    Great

  • @raginijaiswal9377
    @raginijaiswal937710 ай бұрын

    👍 Thanks

  • @jitendrasutar1735
    @jitendrasutar17357 ай бұрын

    Nice❤❤❤❤

  • @dhirajyadav5486
    @dhirajyadav5486Ай бұрын

    Perfect than you

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Means

  • @user-sh3jk9sy3u
    @user-sh3jk9sy3u23 күн бұрын

    Formula not working when data are in two different files..please advise..

  • @SKLearningJunction

    @SKLearningJunction

    22 күн бұрын

    I will make a new video on this

  • @Ak_computer_Gyan
    @Ak_computer_Gyan4 ай бұрын

    It's amazing sir 🎉 but if i have a big data, so how can i solve it❤ (Thanks for this video)

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    Pls watch this full brief video tutorial on large data. kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @zeem113
    @zeem113Ай бұрын

    Nayi how , after columns 13,17 KO select kro data Ka liya ye nayi uthata data

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Watch this tutorial kzread.infojryLSTejD8M?feature=share

  • @MC.Millionair
    @MC.Millionair Жыл бұрын

    Mera bhot time save hua is video se. Morning se laga hua tha isme but sirf proper formula apply Kiya 10 min k under kaam ho gya. Thank you so much bhai🙏 Aasif.

  • @arunkumar4u

    @arunkumar4u

    11 ай бұрын

    Kya kaam karta hai bhai?

  • @MC.Millionair

    @MC.Millionair

    11 ай бұрын

    @@arunkumar4u IT me hu bhai

  • @santoshpatnaik30
    @santoshpatnaik3025 күн бұрын

    Can I use this formula in 2007 and 2010 version..?

  • @SKLearningJunction

    @SKLearningJunction

    25 күн бұрын

    Yes

  • @ExcelPro.
    @ExcelPro.3 ай бұрын

    Nice... I want to learn dashboards ❤❤

  • @SKLearningJunction

    @SKLearningJunction

    3 ай бұрын

    Ok

  • @laxmithakur1990

    @laxmithakur1990

    2 ай бұрын

    Superb 😊

  • @AdithyaAdi-fj4kc
    @AdithyaAdi-fj4kc6 ай бұрын

    ❤👍

  • @aniket12421
    @aniket124212 ай бұрын

    Aur bhot saare columns hoge toh kya kroge ? Sab numbers daaloge kya?

  • @SKLearningJunction

    @SKLearningJunction

    2 ай бұрын

    Uske liyr Vlookup ke sath Match Function apply kro

  • @sanjukolambkar75
    @sanjukolambkar755 ай бұрын

    I tried mera nahi aha raha hai .. exactly same thing I’m doing but getting only one column

  • @SKLearningJunction

    @SKLearningJunction

    5 ай бұрын

    Ok

  • @srikantchhabra9719
    @srikantchhabra9719Ай бұрын

    Formula not working, giving only one column value

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html Pls watch this full video tutorial Formula is correct I think you are missing something

  • @monu8524
    @monu85248 ай бұрын

    Jab mene copy to sabhi ek sath paste nahi huye mene manually column number likha tab value mili. Aisa kyu kya galti hui please bataye

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    Ctrl + enter type kro formula lagane ke bad

  • @GagandeepGagandeep-rm4rl
    @GagandeepGagandeep-rm4rlАй бұрын

    Use nhi ho rha hai multipal vlookup ka formula ???

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Kya error aa rha hai

  • @sunillohat1115
    @sunillohat11153 ай бұрын

    This formula not applying I do not know plz help me

  • @SKLearningJunction

    @SKLearningJunction

    3 ай бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html Watch this full video for better understanding

  • @knowledgeandlearning1293
    @knowledgeandlearning1293Ай бұрын

    Match se bhi hota hai na yahi?

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Yes

  • @RDA905
    @RDA9059 ай бұрын

    Sirf ek hi column ka answer show ho rha h

  • @SKLearningJunction

    @SKLearningJunction

    9 ай бұрын

    Pls watch Full tutorial on my channel page

  • @shaakirsam
    @shaakirsam7 ай бұрын

    Its not working in my file please advise

  • @SKLearningJunction

    @SKLearningJunction

    7 ай бұрын

    Which Excel version you are using?

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

    Sir Maine Same Method Use Kiya Hai Phir Bhi Keval 2 row ke coloums mein vlookup lgaa pure table mein nhi please soution

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Ye method try kro

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @MdTaukeer
    @MdTaukeer7 ай бұрын

    How to skip collom i want only 2,4,5 ( 3rd collon want blank bcoz thair is another data Than how to use in this case

  • @Allinone-sh6cj

    @Allinone-sh6cj

    7 ай бұрын

    You have to use formula 2 times then

  • @SKLearningJunction

    @SKLearningJunction

    6 ай бұрын

    So watch this video

  • @SKLearningJunction

    @SKLearningJunction

    6 ай бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @bhimkpc9012
    @bhimkpc90129 күн бұрын

    Y mere work nhi kr rha yr😢

  • @SKLearningJunction

    @SKLearningJunction

    8 күн бұрын

    Kya error aa eha hai

  • @Hindmahasagarthat
    @Hindmahasagarthat8 ай бұрын

    But it is not happening

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    Pls watch full video tutorial

  • @haridarshansingh4962
    @haridarshansingh49623 ай бұрын

    Bhai nhi ho rha version 2013 hai Excel ka??

  • @SKLearningJunction

    @SKLearningJunction

    3 ай бұрын

    No, office 365 version

  • @SKLearningJunction

    @SKLearningJunction

    3 ай бұрын

    Ekta bar full video tutorial dekh lo channel par jakar

  • @aniket12421
    @aniket124212 ай бұрын

    Nhi ho rha NA aur value aa rha h

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Kya nhi ho rha hai

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

    Sir ye formula only 365 paid Excel mei hi use hota ha

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Yes

  • @beingcreative4548
    @beingcreative45485 ай бұрын

    Mene kiya pat ek hi column Mr lga .. Kuc btaye

  • @SKLearningJunction

    @SKLearningJunction

    5 ай бұрын

    Ok

  • @beingcreative4548

    @beingcreative4548

    5 ай бұрын

    @@SKLearningJunction I mean solution to bataiye ke pure area me nhi lag rha

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

    Nahi aa raha bhai

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Iska full tutorial channel par dekh lo

  • @SandeepKumar-np6pb
    @SandeepKumar-np6pb10 ай бұрын

    Dusri sheet se kese kaam krega

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    Same pattern apply karna hai

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

    Agar 200colums rahatho kaisa karna hai 200 colums ka serial no manually type karna hai kya

  • @amanranaji78

    @amanranaji78

    6 ай бұрын

    Match use kr lo

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    No

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    Use Vlookup + Match Function

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

    got #spill inplace of data let me know how to correct

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Pls watch and follow this

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @ritvikvarshney571
    @ritvikvarshney5714 ай бұрын

    Not working in wps

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    I think it will work

  • @VijaySingh-ur5of
    @VijaySingh-ur5of4 ай бұрын

    Nhi hora h brother

  • @SKLearningJunction

    @SKLearningJunction

    4 ай бұрын

    Pls watch full video tutorial from Playlist

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

    Bhai Index match lga jyada acha rahega

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    kzread.info/dash/bejne/iKWWuteHeb25YLA.html

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Ye thik rahega

  • @jayaasingh
    @jayaasingh7 ай бұрын

    Function not working

  • @SKLearningJunction

    @SKLearningJunction

    7 ай бұрын

    Try again

  • @spritualseek
    @spritualseek9 ай бұрын

    What if our headers doesn't match ???

  • @SKLearningJunction

    @SKLearningJunction

    9 ай бұрын

    Then use vlookup + match function

  • @spritualseek

    @spritualseek

    9 ай бұрын

    @@SKLearningJunction but this works only when our headers match ! If am not wrong

  • @SKLearningJunction

    @SKLearningJunction

    9 ай бұрын

    @@spritualseek Yes, you have match the header

  • @spritualseek

    @spritualseek

    9 ай бұрын

    @@SKLearningJunction So there is no option in condition where headers doesn't match

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

    Sir what if it is upto 40 columms

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Watch this

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @tgcwarrior1762

    @tgcwarrior1762

    Жыл бұрын

    @@SKLearningJunction thank you sir

  • @sureshrb1996
    @sureshrb1996Ай бұрын

    Not working...

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html Watch this complete information

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

    meri is formule se nahi ho pa rhi

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Pls watch this full tutorial

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @jprplay3750
    @jprplay37505 ай бұрын

    Not works properly

  • @SKLearningJunction

    @SKLearningJunction

    5 ай бұрын

    Pls watch full Tutorial on channel

  • @PratibhaTamang-kg8si
    @PratibhaTamang-kg8si3 ай бұрын

    It's not working

  • @SKLearningJunction

    @SKLearningJunction

    3 ай бұрын

    Pls watch full video tutorials from channel for better understanding

  • @chinnaemmadi149
    @chinnaemmadi1496 ай бұрын

    It's not working >>>>>

  • @SKLearningJunction

    @SKLearningJunction

    6 ай бұрын

    Excel version?

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

    Awsome formula but ye data ke bich me date and time rahe to work nahi karta hai

  • @user-nl4ym6ei6w
    @user-nl4ym6ei6w6 ай бұрын

    Nhi लगता

  • @SKLearningJunction

    @SKLearningJunction

    6 ай бұрын

    ?

  • @Deepakkumar-ne1jq
    @Deepakkumar-ne1jqАй бұрын

    Not worked

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    What showing

  • @harshkushwaha01
    @harshkushwaha0111 ай бұрын

    NOT WORKING

  • @SKLearningJunction

    @SKLearningJunction

    11 ай бұрын

    What

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

    Not working

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    Watch full tutorial on channel

  • @harshapulipaka4201

    @harshapulipaka4201

    Жыл бұрын

    Xl version before 2013

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

    It's not comg

  • @SKLearningJunction

    @SKLearningJunction

    Жыл бұрын

    What ?

  • @motivationguru2.055
    @motivationguru2.055Ай бұрын

    Nahi lag raha hai fake ha in

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Fake kaise ho skta hai

  • @dabhidivyang4
    @dabhidivyang411 ай бұрын

    Thanks for supporting, but jis sheet me vlookup lagaya usme se ak columm me likha hua change Kiya to baki column blank ho gai , please support

  • @SKLearningJunction

    @SKLearningJunction

    11 ай бұрын

    Watch this tutorial

  • @SKLearningJunction

    @SKLearningJunction

    11 ай бұрын

    kzread.info/dash/bejne/d5qssZaHfJewcrA.html

  • @Creativerachu
    @CreativerachuАй бұрын

    This trick is not working

  • @SKLearningJunction

    @SKLearningJunction

    Ай бұрын

    Not possible, pls watch full video tutorial

  • @Creativerachu

    @Creativerachu

    Ай бұрын

    I have seen completely video. But It's not working just find only one cell value through vlookup formula. Because,I tried many times. Is it necessary any special version of Ms - Excel to using this formula? Please give me clarity

  • @kishanprajapat8779
    @kishanprajapat87795 ай бұрын

    Great

  • @DriveExpress734
    @DriveExpress7344 ай бұрын

    It's not working

  • @SKLearningJunction

    @SKLearningJunction

    3 ай бұрын

    Watch full video tutorial from channel for better understanding

Келесі