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
This is better than Sequences and column functions
Waaaah!!! Yhi dhoondh rha tha mai, thankyou!!!
Nice tricks. Thanks a lot.
Thank you so much bro it was really helpful for me.
Better explained than any other video. 👍👌👏
Mujhe bahut help mili hai isse ❤❤
@SKLearningJunction
Жыл бұрын
👍
Thank you bro it was really helpful for me
It saved ME hours wow
good tutorial, thank you
Seriously thank you 😊
Thank you so much
انت فشيخ ياض❤
Thanks so much
@SKLearningJunction
11 ай бұрын
You're welcome!
Thanks ❤❤❤
thank you sir
Thank You
Ni lga 2016 me. Cntrl shift enter se hoga or vo b only uppar ki ek hi cell niche wali nhi ho rhi
Amezing sir
Great
👍 Thanks
Nice❤❤❤❤
Perfect than you
@SKLearningJunction
Ай бұрын
Means
Formula not working when data are in two different files..please advise..
@SKLearningJunction
22 күн бұрын
I will make a new video on this
It's amazing sir 🎉 but if i have a big data, so how can i solve it❤ (Thanks for this video)
@SKLearningJunction
4 ай бұрын
Pls watch this full brief video tutorial on large data. kzread.info/dash/bejne/d5qssZaHfJewcrA.html
Nayi how , after columns 13,17 KO select kro data Ka liya ye nayi uthata data
@SKLearningJunction
Ай бұрын
Watch this tutorial kzread.infojryLSTejD8M?feature=share
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
11 ай бұрын
Kya kaam karta hai bhai?
@MC.Millionair
11 ай бұрын
@@arunkumar4u IT me hu bhai
Can I use this formula in 2007 and 2010 version..?
@SKLearningJunction
25 күн бұрын
Yes
Nice... I want to learn dashboards ❤❤
@SKLearningJunction
3 ай бұрын
Ok
@laxmithakur1990
2 ай бұрын
Superb 😊
❤👍
Aur bhot saare columns hoge toh kya kroge ? Sab numbers daaloge kya?
@SKLearningJunction
2 ай бұрын
Uske liyr Vlookup ke sath Match Function apply kro
I tried mera nahi aha raha hai .. exactly same thing I’m doing but getting only one column
@SKLearningJunction
5 ай бұрын
Ok
Formula not working, giving only one column value
@SKLearningJunction
Ай бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html Pls watch this full video tutorial Formula is correct I think you are missing something
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
4 ай бұрын
Ctrl + enter type kro formula lagane ke bad
Use nhi ho rha hai multipal vlookup ka formula ???
@SKLearningJunction
Ай бұрын
Kya error aa rha hai
This formula not applying I do not know plz help me
@SKLearningJunction
3 ай бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html Watch this full video for better understanding
Match se bhi hota hai na yahi?
@SKLearningJunction
Ай бұрын
Yes
Sirf ek hi column ka answer show ho rha h
@SKLearningJunction
9 ай бұрын
Pls watch Full tutorial on my channel page
Its not working in my file please advise
@SKLearningJunction
7 ай бұрын
Which Excel version you are using?
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
Жыл бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
@SKLearningJunction
Жыл бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
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
7 ай бұрын
You have to use formula 2 times then
@SKLearningJunction
6 ай бұрын
So watch this video
@SKLearningJunction
6 ай бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
Y mere work nhi kr rha yr😢
@SKLearningJunction
8 күн бұрын
Kya error aa eha hai
But it is not happening
@SKLearningJunction
4 ай бұрын
Pls watch full video tutorial
Bhai nhi ho rha version 2013 hai Excel ka??
@SKLearningJunction
3 ай бұрын
No, office 365 version
@SKLearningJunction
3 ай бұрын
Ekta bar full video tutorial dekh lo channel par jakar
Nhi ho rha NA aur value aa rha h
@SKLearningJunction
Ай бұрын
Kya nhi ho rha hai
Sir ye formula only 365 paid Excel mei hi use hota ha
@SKLearningJunction
Жыл бұрын
Yes
Mene kiya pat ek hi column Mr lga .. Kuc btaye
@SKLearningJunction
5 ай бұрын
Ok
@beingcreative4548
5 ай бұрын
@@SKLearningJunction I mean solution to bataiye ke pure area me nhi lag rha
Nahi aa raha bhai
@SKLearningJunction
Жыл бұрын
Iska full tutorial channel par dekh lo
Dusri sheet se kese kaam krega
@SKLearningJunction
4 ай бұрын
Same pattern apply karna hai
Agar 200colums rahatho kaisa karna hai 200 colums ka serial no manually type karna hai kya
@amanranaji78
6 ай бұрын
Match use kr lo
@SKLearningJunction
4 ай бұрын
No
@SKLearningJunction
4 ай бұрын
Use Vlookup + Match Function
got #spill inplace of data let me know how to correct
@SKLearningJunction
Жыл бұрын
Pls watch and follow this
@SKLearningJunction
Жыл бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
Not working in wps
@SKLearningJunction
4 ай бұрын
I think it will work
Nhi hora h brother
@SKLearningJunction
4 ай бұрын
Pls watch full video tutorial from Playlist
Bhai Index match lga jyada acha rahega
@SKLearningJunction
Жыл бұрын
kzread.info/dash/bejne/iKWWuteHeb25YLA.html
@SKLearningJunction
Жыл бұрын
Ye thik rahega
Function not working
@SKLearningJunction
7 ай бұрын
Try again
What if our headers doesn't match ???
@SKLearningJunction
9 ай бұрын
Then use vlookup + match function
@spritualseek
9 ай бұрын
@@SKLearningJunction but this works only when our headers match ! If am not wrong
@SKLearningJunction
9 ай бұрын
@@spritualseek Yes, you have match the header
@spritualseek
9 ай бұрын
@@SKLearningJunction So there is no option in condition where headers doesn't match
Sir what if it is upto 40 columms
@SKLearningJunction
Жыл бұрын
Watch this
@SKLearningJunction
Жыл бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
@tgcwarrior1762
Жыл бұрын
@@SKLearningJunction thank you sir
Not working...
@SKLearningJunction
Ай бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html Watch this complete information
meri is formule se nahi ho pa rhi
@SKLearningJunction
Жыл бұрын
Pls watch this full tutorial
@SKLearningJunction
Жыл бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
Not works properly
@SKLearningJunction
5 ай бұрын
Pls watch full Tutorial on channel
It's not working
@SKLearningJunction
3 ай бұрын
Pls watch full video tutorials from channel for better understanding
It's not working >>>>>
@SKLearningJunction
6 ай бұрын
Excel version?
Awsome formula but ye data ke bich me date and time rahe to work nahi karta hai
Nhi लगता
@SKLearningJunction
6 ай бұрын
?
Not worked
@SKLearningJunction
Ай бұрын
What showing
NOT WORKING
@SKLearningJunction
11 ай бұрын
What
Not working
@SKLearningJunction
Жыл бұрын
Watch full tutorial on channel
@harshapulipaka4201
Жыл бұрын
Xl version before 2013
It's not comg
@SKLearningJunction
Жыл бұрын
What ?
Nahi lag raha hai fake ha in
@SKLearningJunction
Ай бұрын
Fake kaise ho skta hai
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
11 ай бұрын
Watch this tutorial
@SKLearningJunction
11 ай бұрын
kzread.info/dash/bejne/d5qssZaHfJewcrA.html
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
Great
It's not working
@SKLearningJunction
3 ай бұрын
Watch full video tutorial from channel for better understanding