Multiple Columns Vlookup in Excel - VLOOKUP, Return Multiple Columns Values
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- 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?
---------------------------------------------------------------------------------------------------------------------------
Download Practice file :- tynorind-my.sh...
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.
Playlist of Sum Related formulas.
• All Sum Formulas of ex...
Tags.
vlookup,
vlookup in excel ref error hindi,
vlookup with multiple criteria,
vlookup in excel,
vlookup formula in excel,
vlookup between two worksheets,
vlookup tutorial for beginners,
vlookup and hlookup in excel,
vlookup and match in excel,
vlookup advanced excel,
vlookup excel tutorial indonesia,
vlookup function in excel,
vlookup formula in excel for two different sheets,
vlookup function,
vlookup for multiple lookup values,
vlookup formula in excel in hindi,
vlookup in excel in hindi
multiple columns vlookup,
multiple columns vlookup basics,
multiple columns vlookup hindi,
multiple columns vlookup kya hota hai,
multiple columns vlookup lessons,
multiple columns vlookup video,
multiple columns vlookup youtube
How to use vlookup for multiple columns in hindi
vlookup multiple columns in hindi
Excel Tutorial
Multiple Values Vlookup
Vlookup with Match Function
Vlookup Multiple Criteria
Multiple Columns Vlookup (Hindi) | Excel Tricks by Value Learnings
Excel - VLOOKUP, Return Multiple Columns, Advanced Lookups
Vlookup to Get Complete Record | Column , Columns | Lookup Full Record
Use Array in V-lookup to get Multiple columns value
Multiple Columns Vlookup in Excel - VLOOKUP, Return Multiple Columns Values #Vlookup #excel #formula
#Vloopkup
#AdvanceVlookup
#Multipecoulumnvlookup
#Howto
#Whatisvlookup
#Advancevlookup
#SKLearningJunction
#SurajKumar
Multiple Columns Vlookup (Hindi),
How to use vlookup for multiple columns in hindi
vlookup multiple columns in hindi
Excel Tutorial
Multiple Values Vlookup
Vlookup with Match Function
Vlookup Multiple Criteria
vlookup in excel,vlookup,advanced vlookup,advance vlookup,vlookup formula,excel vlookup,vlookup function,vlookup formula in excel,excel vlookup tutorial,advanced excel,vlookup tutorial,vlookup in excel in hindi,how to use vlookup,excel vlookup advanced,how to use vlookup in excel,excel vlookup formula,vlookup excel,vlookup for multiple lookup values,vlookup and hlookup in excel,how to do vlookup,vlookup hlookup in excel,vlookup multiple criteria,vlookup with multiple criteria,vlookup,vlookup for multiple lookup values,vlookup with multiple criteria in different columns,multiple criteria,multiple vlookup,vlookup with multiple criteria in excel,lookup multiple criteria,index match multiple criteria,lookup data using multiple conditions,multiple vlookup criteria,excel vlookup multiple criteria,vlookup multiple criteria in excel,how to vlookup with multiple criteria,ms excel - lookup full record,lookup full record,ms excel,vlookup,vlookup function,excelvlookup function,vlookup to lookup whole record,vlookup with columns formula,vlookup full records,vlookup formula in excel,vlookup in excel in hindi,vlookup column,column function in excel,vlookup with columns function
भाई इससे अच्छा =Vlookup(C2,C2:E6,{2,3,4,5,6},False) इसका इस्तेमाल करेंगे ना जिससे सभी मे value एक साथ आ जायेगी।
Ye video dekho iski bat kar rhe ho aap. th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Correct bro
Nhi aati bhai
@@ajitturan424Bro aati h formula lagane ke bad ctrl+shift+Enter kro
🎉🎉🎉
Thank SK bhai....Very helpful video.
Vlookup+ match
Function se 1 time me sabhi data ko utha sakte hai
Yes bro
Fantastic very early solve thanku sir
👍🙏
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
ye to 10-12 columns tha toh ho gaya agaar 20-30 se jayada columons hoga toh ? sara din lag jayega count karte karte uske sath time bhi ,aur boss ko kaise apna kam dunga ? simple vlookup ke sath columns formula apply karo na jaldi ho jaye ga .
Bro. Try this method 👉👉th-cam.com/video/AL7YNptUeNU/w-d-xo.html
Column +vlookup lgane ki jarurat nhi
Love this info it's very useful thank you
Thanks bro... I have learnt this..
I think you need to learn this also -
th-cam.com/video/6HXEAdADE-Q/w-d-xo.html
Excellent video 😌😌
thanks bro
thanks bro
Bhai match ka formula vlookup me permanent solution hai
Aapne 9 coulman me lagaya agar aage hajaro column hai tab aap aise hi karoge kya
Pls watch this tutorial
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Thanks so much dear Sir for easy and good knowledge really very thanks dear Sir
👍
Thank u sir
Hello sir
If error use karke vlookup ki video banao sir..❤
Ok
Bhai ise accha hota ki aap column no ki jagah coloumn ka formula laga kar drag kar dete to isse kam time lagta
Ok bro, but humen aur bhi method aane chahiye.
Thanks for your suggetion
@@SKLearningJunction Column formula ki koi video hai apki?
Sir mujhe ye verify karna hai ki jo data Mera match hua hai use mein jis sheet se match Kara raha hoon vo kis row mein match hua ye kaise pata Karu please suggest me
apply reverse lookup
wow Amazing
Thanks
Bhai sabse badiya column index number aise manual likhe ki jagah match ka formula laga do vlookup k sath maza aa jayega automatic column number le lega
Bhai iske upar Alag se video bnai hai
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Kya naya bata diya
Bro isme btaya hai naya
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Good one
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Any option that we don't need enter column no. Manual
th-cam.com/video/01aFWgOrZUU/w-d-xo.html
Watch this tutorial
Is sheet contains more then 100 columns then what will do
Then use Vlookup + Match Function th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Brother you have to work on your Excel skill. Bar bar index no. Dalkar change krne ki need nai hai.
Isko aise kr sakte hai.
=Vlookup,table array,{2,3,4,5,6,7,8,9},0) then ctrl+shift and enter. Pura formula khud hi sare rows me lag jayega.
Vdo bnate ho to easy or logically cheeze btao jugaad nahi
Yes that's why I have make this tutorial also
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
thanks bhai
Columns formula use ho skta hai idhar
Yes
Good
Its not working on excel 2016.. Can you explain it??
It will work when you will copy the full formula from formula bar then paste in another column and change index number
very informative, thank you so much for uploading this video
👍🙏
ye to 10 c 12 column the to us p no. edit kr diye...bt agr 100 column ho to is tarah se to kafi time jayge aur confusion bi hoga.
Ye try kro aap
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Agar 1500 columns ho toh pura din baithkar yahi krte rahe
No ye method try kro one time ho jayega
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Innozant channel says this type vlookup is wahiyat vlookup and I agree 😐😐
You can't judge from one video to entire channel watch this then say
th-cam.com/video/iC7oQJvb8iQ/w-d-xo.html
Bhai apne to freeze bataya hi ny apne to dollar ka sign lgaya h formule me to uske bare b bta do
Ok
Bhai index number automatically kaise change hoga isi formula me??
Watch this
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Sir, Vlookup ke sath Match function use kar sakte hai yaha.
Yes
Apne shortcuts nhi bataya ye to bahut lamba process hai sir g isse shortcuts hame pata hai
Ye try kro easy hai
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Bhai likes this video I solved my multi colom vloook issue 🙏 a lot ji bhar ke Jio yaar tum🎉🎉 God bless you dost.
Thankyou
Bhai maine socha kuch nya sikhaoge...par isse accha to Vlookup Match , Index match h ek hi baar main sara fill ho jata h ...aap bhi woh sikho 😂
Bhai vlookup par 4 to 5 videos Dali hai aap ye try Karo
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
🤣🤣
Nice video ❤💯💥
👍
Large Data par yeh formula sahe result nhi de rha hai .
Try this
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Bhai but next colum me NA aara he
Aap isko proper open karke copy and paste kro
Multipl code ka formula btaye
Watch this video
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Nice Bro
🙏
Nice
Thanks
Not working for me . Only 2 column data received, rest error #REF!
Sir, try this method
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Bhai ye sahi nhi hai isme bar bar index numbers change karna pad rha hai
I know but Jo Maine is video me
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html btaya hai isme nhi karna padega
in this video vlookup process is very lengthy, we can use vlookup with columns vlookup with match
th-cam.com/video/EfxO4NL4JBM-/w-d-xo.html in this very simple
Absolutely right bro v lookup with column
Well said bro
Pagal banriya hai
Supar sir thank you
Bhaiya me bhi ye trick main bhi use karta hoon lekin mera pura kaam nahin ho raha hai
Kya problem aa rhi hai?
Vlookup+ Match bhi use kar sakte ho
Superb ✌️
🙏
Bhai paste krne ke baad #NA ku Ara he dusre colum me
Aap formula ko open kro the poora select kro and copy karke paste kr do
Very Lengthy Process, Isse bdiya match function lgaalo baar baar mannual kon krega .. AI ka jamana hai sir thoda automate Krna dikhaao bacho ko
Yes you are right but I have uploaded approximately 10 videos on vlookup so request you to watch this video first th-cam.com/video/iC7oQJvb8iQ/w-d-xo.html
You cannot judge everything from a single videos
How to compare sheet 1, Column A + Column B value to sheet 2' Column A + Column B value
very use ful
but kuch aisa nhi ki number na dalne pade
Yes, ye try kro manually Serial number nhi dalna padega
th-cam.com/video/EfxO4NL4JBM/w-d-xo.htmlsi=FWbFz0QfcrBMu8iO
I have one question
What?
Yes pls
Bhai कॉलम number change karte hi NA ka error aata hai😢
Formula ko F2 se open karna hai then select all copy and paste . Then change Number
sir , plz upload pratice file of this video.
Ok
@@SKLearningJunction sir please Share the Vlookup+ match video wala practice file.
not very help full it will take enough time. we can try some more ways
You need to try the xlookup
That's good function
Abhi dukhi hu mai... Kuchh samjh nhi aaya jb aayega tb thank you sir likhungi
Ok
please give link for practicing, practice file upload
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html try this practice file also
It will take more time , we can use vlookup and match formula for multiple coloumn
What about the index Match th-cam.com/video/AL7YNptUeNU/w-d-xo.html
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html - watch this tutorial
this is not an multilookup formulla its manual work , you dont know this
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Watch this video
Vlookup not working all sheet , refe
it will work, please confirm what is the actual problem
Nice video pls provide training video on entire conditional formatting its urgent
Please watch videos from this playlist of Conditional Related -th-cam.com/play/PLpIpH99tLOxIxrP1KTiff6Wys7xatbH7e.html
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html try this
Bhai advance sey banavo and short time sey plan Karo next time s 🔥🔥
Ok
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html try it
Hd h mtlb gajab mje le liye bhaishab aapne toh kuch nahi btaya aapne
Ok, aapko kuch nya sikhna hai to ye dekho th-cam.com/video/iC7oQJvb8iQ/w-d-xo.html
Thank you ! It’s informative video
Thanks, pls subscribe this channel
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html Try this more informative
formula paste kese hoga
Ctrl C then enter and Ctrl V.
Bhayyu is se achha to hum vlookup k sath match use kr lete to ye vdo 3 minute me ho jata.
Ok, but you can try the xlookup it's better than vlookup and match
th-cam.com/video/liI3jqFigX4/w-d-xo.html
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html - ye try karke dekho
Kya Naya bataya ? Bahut lambi formula hai, aur bhi choti formula like columns formula easy and fast.
Bhai xlookup try kro
Bilkul simple aur asan formula hai th-cam.com/video/liI3jqFigX4/w-d-xo.html
Bhai xlookup try kro
Bilkul simple aur asan formula hai th-cam.com/video/liI3jqFigX4/w-d-xo.html
th-cam.com/video/EfxO4NL4JBM-/w-d-xo.html ye dekho bahi
Waah bhai, dimag bhai dimag.
(Sarcasm)
😊
Ye excel me nji work krta hy
Kon sa Excel version hai
Very informative Thank you
It was very basic. I dont know whats new ?
But I think this is the new for you
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Formula thik hai
Perfect nahi
Koi aisi trik batao jisase ek bar formula use se kai colum ke data find kar paye
Video already uploaded
I came here to check how to use vlookup in multiple columns but this man just use a normal vlookup formula.........just wasted
Try this man,you will shock
Ye kya h. Vlookup+columns use kro iske liye.
Yes, you can use Vlookup + Match Function also
Go learn more
Sister it was just trailer, I no many more
Watch more videos pls
th-cam.com/video/rSx_3N5i_d0/w-d-xo.htmlsi=uEiWe5fDu4hbz3lP
बहोत बहोत धन्यवाद सर
Nice vedio sir 👌🏻👌🏻
Thanks bro
Tricky hai
Time pass video
And this one
th-cam.com/video/EfxO4NL4JBM/w-d-xo.htmlsi=ZbPC0nMan-cWgTaW
bhayya kya sikha rahe ho yaar ye...
jo aap sikha rahe hain use manual formatting kahte hai
Ok
Isse acha v look me match formula put kr lenge Bhai ye bht irritating h
It's a another way to apply vlookup but you right & talking about this method th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Thanks for this information 😊
This is not working
Not possible
Interview me aise karega na bhai, 1 sec me reject karke gaun bhej dega
Isliye to Maine ye video bnai Hain
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Ye to manual ho gya isse better xlookup lga lo friends
Yes but have to watch this
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Bhai ye chutiya bana raha h job work me itna time or itna Chhota data nahi rahta
Excellent
Very helpful
Itna galat information q dete ho bhai, agar
500 column data hoga tab sab m krte rhe ge kya bhai TH-cam se videos dekh k videos banate ho kya
Kuch v
Brother ye bhi alg tarika hai
Long data ye method Follow kro
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Sorry !
Thank you ❤
Very Helpfull video
Shandaar
It's very lengthy process
Watch this
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Itni mehnat hi karni hoti to trick kyu dhundhta😑
Pls try this one
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Very informative.
क्या यार
क्यों समय बर्बाद कर रहे हो।
मैच के साथ volookup लगा लो
Yes you are right but bahut logo difficultly hoti vlookup ke sath Match apply krne me
I have also make videos on this
Bhai video dalni band kar do
Class 6th ki cheej mat sikhao
Match ka formula lagana seekh lo
Maine dislike Kiya hai
Kyoki meri ⁷ minutes kharab kar di hai
Ek video me kisi ko judge nhi karte. Ye video bahut time phle Dali thi vlookup ki playlist dekhlo ek bar aapko bahut sari videos milegi jiske bare shayad hi aapko aata hoga
th-cam.com/video/6HXEAdADE-Q/w-d-xo.html
kuch bhi bakwas...... 100 coloum honge to kya ek ek type krege.... bs vidoe banna h to kuch bhi bana do
Aisa nhi hai o bhi ek way hai lookup ka bahut log use krte hai baking multiple columns lookup ke liye ye try kro
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Abe bhai kyu time brbad kiya ,ek bar me bata ye to manually ho gya ..Ye to sabko pata he
Ye try kro
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html
Bakwas. Pehly khud sekh le bhai ayse nhe hota Vlookup. For example if we choose wrong number, then how we will find the issue?
Mr. I have uploaded to 9 videos on vlookup watch that
then say this type of bad words
Normal ha
It's very lengthy process. I can fill full shit in one vlookup formula
Yes I know pls try this
th-cam.com/video/EfxO4NL4JBM/w-d-xo.html