#shorts #vlookup #vlookupformula by using VLOOKUP with MATCH you can lookup your data in a dynamic way. MATCH functions provide column index number to the VLOOKUP function based on your data header.
Guys these trick is amazing but let me tell you if you are using 2021 version or 365 days of excel version just use vlookup function you don't meed to use match function just givr your "Lookup value,table array, in the column index number use curly bracket like {2,3,4} ,0 ctrl+ enter you will also get the same result it depends upon you how you are using
Great sir maja aa gaya shuru me babut problem aai fir comment pad kr solution mil gaya usme funda f4 press krne ka hai. Please aap ek video me f4 ko acche se clear kr dijiye.
I like your video I want to ask you that which software you use for video editing, how you are moving screen in shorts video you might understood my question thanks in advance?
Agar Aap Sabhi range ko ek sath select kar ke f4 press karte hai to sabhi me ek hi type se dollar lagega. Alag alag range ko alag dollar lagana ho to use one by one select kar ke hi dollar lagana hoga
Me bhi yehi dekh Raha the ki ek sath ans kese laye me har column me alag alag jakar v lookup use karta tha Par Aaj se Ctrl + enter use karunga ok thanks 🙏🙏🙏 sir ji
You will get only record which comes on top or first. If you want to lookup all corresponding where data is duplicate follow the steps describe in the video. link is below. th-cam.com/video/N7HRufrFGuE/w-d-xo.html
हर जगह रेंज या सेल को उसके जरुरत के आधार पर फिक्स किया जाता है। उदाहरण के लिए किसी सेल में सिर्फ उसके कॉलम को फिक्स करना है तो उसके कॉलम के पहले डॉलर लगेगा ($A1) किसी सेल में सिर्फ उसके रो को फिक्स करना है तो उसके रो के पहले डॉलर लगेगा (A$1) अगर जरुरत हो पुरे सेल को फिक्स करने की तो डॉलर रो और कॉलम दोनों के पहले लगेगा ($A$1) बहुत जल्दी इसपे एक वीडियो आने वाली है। जिसमे एक्सेल के सेल रेफरेंसिंग और डॉलर साइन को इस्तेमाल करने के तरीके के बारे में बताया गया है।
Usefull ! Simple and on point without unnecessary talk ..
Glad it was helpful!
Gazab bhai itna aasan koi nhi batata sab gyan dene lagte h 😂 Thank you to crack this in 30 sec. 😊😊
Thanks for your valuable feedback.
Well aap VLOOKUP ki detail video is link me dekh sakte hai.
th-cam.com/video/w-lJ-NvdMlM/w-d-xo.html
Great trick.... I am searching this easy way of pulling data. 😊
👍
@@ExcelUniverse for freez cell how many times press f4 key
Single press $A$1
Two Times A$1
Three times $A1
Coloum ko Freez kaise karte hain
Press function key F4 after selecting column
Guys these trick is amazing but let me tell you if you are using 2021 version or 365 days of excel version just use vlookup function you don't meed to use match function just givr your "Lookup value,table array, in the column index number use curly bracket like {2,3,4} ,0 ctrl+ enter you will also get the same result it depends upon you how you are using
nice 👌
@@ExcelUniverse. Pardon Sir,I may have hurt you but solution tak pahuchna ka bht saare raste hote h
Finally learned vlookup with full clarity ❤❤ concept cleared fully ..thank you 😊
Glad to hear that
One of the best trick. Thankyou sir
Most welcome 🙏
Thank you 👍
You are welcome
tried 20times show error
but finally i learn thank you so much bro...
Nice to see your efforts 👌 💪
@@ExcelUniverse bro when I lock the cell on that time it's not shows result it show only on cell value brother can you help me please...
Sure, can you pls share the file where you applied formula
Whatsapp @9708153000
@@ExcelUniverse shared 👍
@@nazim9681
Thank you, sir! Was pissed off as couldn't find the exact value for bigger table. Thanks a ton
Most welcome
Thank you so much😊😊😊
Most welcome 🙏
Verry easy explanation
Glad you think so!
Amazing exactly what i was looking for I'll try it , thank you
Most welcome 🙏
Great sir maja aa gaya shuru me babut problem aai fir comment pad kr solution mil gaya usme funda f4 press krne ka hai. Please aap ek video me f4 ko acche se clear kr dijiye.
Thanks for your valuable feedback,
Cell referencing ke bare me or jyada jankari ke liye click on the link
th-cam.com/video/xz2G2BkW0qg/w-d-xo.html
Easy to explain ❤
Glad you think so!
Thank you boss...pahali baar sahi Vlookup Sikh liya❤
Achha hua comment padh liya, $ manually laga raha tha, lo ab vo bhi pata chala 😂😂😂
Thanks 😊
@@ExcelUniverse
Boss still watching your videos 😄.
Sir ji aap ne tho problem solve kardi meri thank you
It's my pleasure 🙏
BY CNYTL+ENTER, ITS JUST GIVING THE ENTER WITHIN A ROW.
Ctrl+Enter nothing just copying same formula in all selected ranges of cells.
If you find some issue you may contact me on WhatsApp 97081 53000
Thanku sir ❤
Most welcome 😊
nice explaination 👍
Thank you 😃
Great. इसी फॉर्मूला को खोज रहे थे।
and finally you have it 😊
Thanks alot ❤
Most welcome 🙏
Great ❤
👍😊
Thank you so much, this helped me a lot!!!
Glad it helped!
Superb...thanks
Welcome 😊
Thank you bro
Welcome
nice
Thanks 😊
First F4 press three times and after that one time and after match formula F4 press f4 two times after that F4 press one time.. It will work 100%
👌
Aapne perfectly clear kr diya.
Thanku sir very helpful this comments again thanku
very very helpful this comments thanku
Thank you so much 😊 bhai
Most welcome 😊
Thank u.. i got it.. formula its working 👍
Great 👍
You used word freeze the column, didn’t get how to freeze the column. Please help
by using $ sign you can freeze the range of cells, the shourtcut key to freeze is function ke F4
Thank you so very much bro
Happy to help
Will try definitely. Great
All the best
Thank you
You're welcome
Hi...Dear brother...Thank you so mush for this video...God bless you and your family
Most welcome 😊
Helpfull session 🙏😊
Glad to hear that
@@ExcelUniversesir plz same hlookup ki video kaha h aapki mujhe mil nahi Rahi h plz link share kijiyena
th-cam.com/video/LRzfKmZjtKk/w-d-xo.htmlsi=oxLsMnqSHqTszSYX
th-cam.com/video/-9ZSkRY7DOw/w-d-xo.htmlsi=2dBRNRONR60Wpw05
Thank you so much sir
Most welcome 🙏
Thanks but how did you freeze the column ?
After selection of range press Function key F4 to fix/freeze
Gajab h bhai...
🙏
If you freeze $ sign comes before F10 like $F10, but if I freeze by function f4 it shows $F$10 and at the end it shows REF
Press F4 three times
@@ExcelUniverseplease speak in video learner don't know how do this
Thanks for your suggestion, I will include it next time
Thank you
Bhai applying vlookup on 2nd column for name is easy and quick and just copy paste to the next column.
😊
Nice 👍
Thank you! Cheers!
Excellent 👌
Thank you! Cheers!
Great Sir ❤ but Sir agr kisi single cell ke data agar search krna hoga to yhi formula apply karna hoga
Yes
thank you sir
😊
Thanks a lot
🙂
Sir ya sabse easy formula hai
Isase Bhi easy hai LOOKUP Function.🙂
Thank you so much
You're most welcome
I like your video I want to ask you that which software you use for video editing, how you are moving screen in shorts video you might understood my question thanks in advance?
Techsmith
@@ExcelUniverse Thanks! 😊
😊
What to do if column names are different between two tables
It's necessary to use same name of column if using match inside vlookup, else you have to input column index number manual.
Is it possible by this function to change data in the searched table and automatically it reflects in the main table?
No! You can't edit the records or cell contain with formula.
But it's possible in Ms Access or via Excel VBA.
@@ExcelUniverse thank you for the reply. I was searching online to get the answer for the last couple of days.
It can be also done with fillter
Yes, but it's all only in o365 and o2021
Thank sir ❤ reply bhi aapne bhot fast Diya Thaku sir🙏
😊
Great
Thanks 🙂
Great sir ❤❤
Thanks 😊
Hi..my one is not working as I am trying to do it from sheet1 to sheet2 .
Can you please share your where you applied formula, Whatsapp @9708153000
It's not working because in vlookup we freeze frst cell of employee code so it does not work in all table
Can you please share the file where you applied formula and result is not as required.
Whatsapp@9708153000
Even I am also facing this problem
Thanx Sir.....❤️
Most welcome
Hello bhaiya maine iss formula ko try kiya par ya row wise aay raha hey par columns wise n/a aay rhi hey ple help kariye
Apni File WhatsApp Kariye, 9708153000
I try this and shown as “This command isn’t available” can you tell me why?
Can you please share a snapshot of the error. Whatsapp me 97081 53000
Excel Universe lekin v look up k baad aur match k baad alag alag jagah par dollar h, f4 se to same hota hai, manually karna padta h kya dollar
Agar Aap Sabhi range ko ek sath select kar ke f4 press karte hai to sabhi me ek hi type se dollar lagega.
Alag alag range ko alag dollar lagana ho to use one by one select kar ke hi dollar lagana hoga
Can it be used for multiple sheets in the same workbook?
It's depends on the senerio.
Well you can share a sample data with desired result.
Whatsapp 97081 53000
Mee 1 week se yahi trick dundh Raha tha.. thanks sir🙏
Kyuki mera work pura excel ka hain aap aise video banate rahe sir
Thanks 😊
Me bhi yehi dekh Raha the ki ek sath ans kese laye me har column me alag alag jakar v lookup use karta tha
Par Aaj se Ctrl + enter use karunga ok thanks 🙏🙏🙏 sir ji
Kon sa button se freez karange sir
Function key F4
Cell referencing ke bare me or jyada jankari ke liye click on the link
th-cam.com/video/xz2G2BkW0qg/w-d-xo.html
Tq 👌
Thank you too
=vlookup ke baad employee I'd select ke baad coloum freaze ke liye aapne kya Kiya? Please tell me
Freeze colum show nhi karha
Function Key F4 ko 3 Bar Press Kariye, COlumn Freeze Ho Jayega
@@ExcelUniverse cant freeze in windows 11 , its just keep dimming the screen light
Ise badiya xlookup hai
Yes XLOOKUP is the best function ever, But Ye Sirf Microsoft 365, Office 2021 or Online Excel me hi Hai
अगर main list में एक employee id के एक से ज्यादा रिकॉर्ड हो। मतलब main list में एक employee id कई बार रिपीट हो रही हो तो क्या data show होगा?
लिस्ट में जो सबसे ऊपर होगा उसी का रिकार्ड आएगा। VLOOKU, HLOOKUP, MATCH,L और INDEX सभी functions इसी तरह काम करते है।
Awesome
Thanks 😊
thank u sir jee
😊
How do you freeze the column
By pressing function key f4
Thanks
Welcome
@@ExcelUniverse can xlookup do all things what can vlookup do
Yes but it's available in office 364 or 2021 only
Full video banao thoda slow mai mai samjh nahi paya 😅
Checkout the link for full video th-cam.com/video/K1ZMmcRFuto/w-d-xo.html
@@ExcelUniverse thanks Bhai ❤️ thanks for help
Superb
🙂
Screen record ke liye konsa software use kiya apne
Techsmith
Wondershare
PowerPoint
Copy paste karke bhi kar sakte hain na sir
Bilkul Kar Sakte Hai 😊
Kya hum ise 2013 version me use kr sakte he kya ??
बिल्कुल कर सकते हैं
Can we do this one at a time. Like if I put emp1 so all the data should come then for emp8 and so on
Yes
Using FILTER function you can get all the records
Super
Thanks
Great 🎉
😊
Nice
Thanks
Column freeze kaise krenge?
Press function key F4 to freeze
How to freeze while entering the formula
By pressing function key F4
Ok I will try F4 key button
Yes, to freeze cell or range in excel you can press function key F4
If same number comes 2times in master data what will we do
You will get only record which comes on top or first.
If you want to lookup all corresponding where data is duplicate follow the steps describe in the video. link is below.
th-cam.com/video/N7HRufrFGuE/w-d-xo.html
Yeh to bta k pehai data to asscending ya descending main arrange krna hota hai
When using VLOOKUP no need to sort data, it's only required while using the LOOKUP function.
Sir thoda confusing h ki formula kaise lagye h
Is video Ko dekhiye, aapka Confusion clear ho jayega
th-cam.com/video/K1ZMmcRFuto/w-d-xo.html
Sir yeh process har vlookup function pe apply hota hai yha sirf vlookup+match function pe
VLOOKUP Ke sath MATCH column index number laane ke liye use karte hai. Or ye sabhi jagah kam karega.
After the match how it appears the dollar sign in between cell number, should we need to type or any key is there. Please advise me
Use function key F4
@@ExcelUniverse lekin v look up k baad aur match k baad alag alag jagah par dollar h, f4 se to same hota hai, manually karna padta h kya
Yes
@@ExcelUniverse to apka btana chahiye na video me ki manually Krna hai, wo to hamne dekh liya error aaya jab😂
@@ExcelUniverse 👍
You skipped row freeze in your dialogue but did in the excel some people confused
Yes, you are right ✅️
Will remember in future
What is the shortcut to freeze the range
Function key F4
Fridge shortcut key?
Press function key F4
But it doesn’t work . After match if you free it then why G$9 showing . Means $G$9 not showing
It's a partially freeze
$A$1 single press F4
A$1 double press F4
$A1 triple press F4
Woow😮
🙂
Why do we freeze column???
Checkout the link below to know why need to freeze columns
th-cam.com/video/xz2G2BkW0qg/w-d-xo.html
How to apply collum freeze
Use function key F4 to freeze
@@ExcelUniverseme click kiya par eror a raha he😢
@Nafiz_4x please share file on WhatsApp 97081 53000
Reverse vlookup pe ek video kijiye sir please
Reverse lookup ke liye INDEX MATCH use kariye
th-cam.com/video/dSmUGx0_2eA/w-d-xo.html
Ya Microsoft 365 excel me XLOOKUP V use Kar sakte hai
Sir ek cheej isme samkh nhi aayi freez krne ki condition vlookup or match ke bad alg alg he
हर जगह रेंज या सेल को उसके जरुरत के आधार पर फिक्स किया जाता है।
उदाहरण के लिए
किसी सेल में सिर्फ उसके कॉलम को फिक्स करना है तो उसके कॉलम के पहले डॉलर लगेगा ($A1)
किसी सेल में सिर्फ उसके रो को फिक्स करना है तो उसके रो के पहले डॉलर लगेगा (A$1)
अगर जरुरत हो पुरे सेल को फिक्स करने की तो डॉलर रो और कॉलम दोनों के पहले लगेगा ($A$1)
बहुत जल्दी इसपे एक वीडियो आने वाली है। जिसमे एक्सेल के सेल रेफरेंसिंग और डॉलर साइन को इस्तेमाल करने के तरीके के बारे में बताया गया है।
How to match 2 tables, how to find differences in 2 sheets
Use consolidated option, given in data tab
thanks sir
Most welcome 🙏
Good evening sir
😊😊😊