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

[@alijockey164]

This is better than Sequences and column functions

[@kapilsharma2366]

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

[@asaduzzamandaria8731]

Nice tricks. Thanks a lot.

[@RahulSharma-cu4of]

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

[@SurajSingh-ok5pg]

Mujhe bahut help mili hai isse ❤❤

[@SKLearningJunction]

👍

[@RahulSharma-cu4of]

Thank you bro it was really helpful for me

[@fazilsaif4851]

Better explained than any other video. 👍👌👏

[@kunalpatil442]

It saved ME hours wow

[@estordigal8566]

Seriously thank you 😊

[@mostafaeldeeb4134]

انت فشيخ ياض❤

[@softwaredynamicsolutions]

good tutorial, thank you

[@aana12365.]

Thanks so much

[@SKLearningJunction]

You're welcome!

[@arnavaj3392]

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

[@taranjitsingh8516]

Thank you so much

[@danesmith9262]

thank you sir

[@shankarshiva2467]

Thanks ❤❤❤

[@mayankvermaagra]

Thank You

[@pinkey7415]

Amezing sir

[@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]

Kya kaam karta hai bhai?

[@MC.Millionair]

@@arunkumar4u IT me hu bhai

[@jitendrasutar1735]

Nice❤❤❤❤

[@raginijaiswal9377]

👍 Thanks

[@user-qj4mw2mp9j]

Great

[@ExcelPro.]

Nice... I want to learn dashboards ❤❤

[@SKLearningJunction]

Ok

[@laxmithakur1990]

Superb 😊

[@Ak_computer_Gyan]

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

[@SKLearningJunction]

Pls watch this full brief video tutorial on large data. kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@user-sh3jk9sy3u]

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

[@SKLearningJunction]

I will make a new video on this

[@santoshpatnaik30]

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

[@SKLearningJunction]

Yes

[@zeem113]

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

[@SKLearningJunction]

Watch this tutorial kzbin.infojryLSTejD8M?feature=share

[@aniket12421]

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

[@SKLearningJunction]

Uske liyr Vlookup ke sath Match Function apply kro

[@srikantchhabra9719]

Formula not working, giving only one column value

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8 Pls watch this full video tutorial Formula is correct I think you are missing something

[@AdithyaAdi-fj4kc]

❤👍

[@GagandeepGagandeep-rm4rl]

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

[@SKLearningJunction]

Kya error aa rha hai

[@dhirajyadav5486]

Perfect than you

[@SKLearningJunction]

Means

[@RDA905]

Sirf ek hi column ka answer show ho rha h

[@SKLearningJunction]

Pls watch Full tutorial on my channel page

[@MdTaukeer]

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]

You have to use formula 2 times then

[@SKLearningJunction]

So watch this video

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@monu8524]

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]

Ctrl + enter type kro formula lagane ke bad

[@knowledgeandlearning1293]

Match se bhi hota hai na yahi?

[@SKLearningJunction]

Yes

[@sanjukolambkar75]

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

[@SKLearningJunction]

Ok

[@haridarshansingh4962]

Bhai nhi ho rha version 2013 hai Excel ka??

[@SKLearningJunction]

No, office 365 version

[@SKLearningJunction]

Ekta bar full video tutorial dekh lo channel par jakar

[@ankitrai3515]

Nahi aa raha bhai

[@SKLearningJunction]

Iska full tutorial channel par dekh lo

[@bhimkpc9012]

Y mere work nhi kr rha yr😢

[@SKLearningJunction]

Kya error aa eha hai

[@Hindmahasagarthat]

But it is not happening

[@SKLearningJunction]

Pls watch full video tutorial

[@aniket12421]

Nhi ho rha NA aur value aa rha h

[@SKLearningJunction]

Kya nhi ho rha hai

[@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]

Ye method try kro

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@sunillohat1115]

This formula not applying I do not know plz help me

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8 Watch this full video for better understanding

[@beingcreative4548]

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

[@SKLearningJunction]

Ok

[@beingcreative4548]

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

[@shaakirsam]

Its not working in my file please advise

[@SKLearningJunction]

Which Excel version you are using?

[@himanshuhimanshu2097]

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

[@SKLearningJunction]

Yes

[@VijaySingh-ur5of]

Nhi hora h brother

[@SKLearningJunction]

Pls watch full video tutorial from Playlist

[@ritvikvarshney571]

Not working in wps

[@SKLearningJunction]

I think it will work

[@mujahidsharif4561]

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

[@amanranaji78]

Match use kr lo

[@SKLearningJunction]

No

[@SKLearningJunction]

Use Vlookup + Match Function

[@SandeepKumar-np6pb]

Dusri sheet se kese kaam krega

[@SKLearningJunction]

Same pattern apply karna hai

[@rkgraaj]

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

[@SKLearningJunction]

Pls watch and follow this

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@vinayvkm2858]

Bhai Index match lga jyada acha rahega

[@SKLearningJunction]

kzbin.info/www/bejne/jKLFiaiEfr-GZq8

[@SKLearningJunction]

Ye thik rahega

[@sureshrb1996]

Not working...

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8 Watch this complete information

[@jprplay3750]

Not works properly

[@SKLearningJunction]

Pls watch full Tutorial on channel

[@chinnaemmadi149]

It's not working >>>>>

[@SKLearningJunction]

Excel version?

[@DriveExpress734]

It's not working

[@SKLearningJunction]

Watch full video tutorial from channel for better understanding

[@jayaasingh]

Function not working

[@SKLearningJunction]

Try again

[@spritualseek]

What if our headers doesn't match ???

[@SKLearningJunction]

Then use vlookup + match function

[@spritualseek]

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

[@SKLearningJunction]

@@spritualseek Yes, you have match the header

[@spritualseek]

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

[@naghmijamil8810]

meri is formule se nahi ho pa rhi

[@SKLearningJunction]

Pls watch this full tutorial

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@tgcwarrior1762]

Sir what if it is upto 40 columms

[@SKLearningJunction]

Watch this

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@tgcwarrior1762]

@@SKLearningJunction thank you sir

[@Deepakkumar-ne1jq]

Not worked

[@SKLearningJunction]

What showing

[@user-nl4ym6ei6w]

Nhi लगता

[@SKLearningJunction]

?

[@twistttcreater487]

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

[@motivationguru2.055]

Nahi lag raha hai fake ha in

[@SKLearningJunction]

Fake kaise ho skta hai

[@harshkushwaha01]

NOT WORKING

[@SKLearningJunction]

What

[@parasmehandiratta2955]

Not working

[@SKLearningJunction]

Watch full tutorial on channel

[@harshapulipaka4201]

Xl version before 2013

[@dabhidivyang4]

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]

Watch this tutorial

[@SKLearningJunction]

kzbin.info/www/bejne/e5fbgGeEgZl9eK8

[@TheKiranlaxman]

It's not comg

[@SKLearningJunction]

What ?

[@Creativerachu]

This trick is not working

[@SKLearningJunction]

Not possible, pls watch full video tutorial

[@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]

Great

[@PratibhaTamang-kg8si]

It's not working

[@SKLearningJunction]

Pls watch full video tutorials from channel for better understanding