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.
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
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?
Sir ager ek sheet m hum quantity likhite hain aur Chahte hain k wo quantity matlab numbers total ho k doosri sheet m ajayein to us k liye Kya karna parega
Vlookup +choose simple rahega jab header same ho aur mai match kyon lagai sirf vlookup se jab kaam ho jayega. Aur bahot logo ko column freeze Karne ka idea nahi hota jisse confusion hota hai value nahi aane pe.
Hi Sir, I didn't know we could apply the formula in all cells at once, however, this didn't work in my Excel. Is there any issue with either my system or any changes in this formula now.
Hello sir I want to know a editing software or app where I can edit my video from landscape to portrait i.e. I want to record my computer screen but in portrait mode or may be after editing it becomes portrait mode. So is there any free editing software where I can do such editing?
Column header ko match kar ke uska number nahi dega. Agar Koi Column shift hota hai to Column function use karne par uska data v change ho jayega. Jabki match function pure range header ko match karega chahe wo kahi bhi rahe
MATCH फ़ंक्शन कॉलम की पोजीशन को डायनामिक रूप से खोजने में मदद करता है। अगर आप डेटा को एडजस्ट या बदलते हैं, तो MATCH Function डाटा के हैडर के हिसाब से ऑटोमेटिकली एडजस्ट हो जायेगा। जबकि COLUMN फ़ंक्शन एक फिक्स्ड नंबर देता है। अगर आपके डेटा में कॉलम्स एडजस्ट होते हैं, तो आपको मैन्युअली COLUMN नंबर को भी एडजस्ट करना पड़ेगा। th-cam.com/video/K1ZMmcRFuto/w-d-xo.html th-cam.com/video/w-lJ-NvdMlM/w-d-xo.html th-cam.com/video/eJNIGfZ6Hq0/w-d-xo.html
Apne ye to btaya nhi kitni bar kaha pe fridge krna h jldi jldi me vdo bana d kitni problm hori h ab।।। Same cheej ek bar done ho gya but dobara problm shuru ho gyi
Ctrl+Enter sirf copy karne ke liye use Kiya gaya Hai. Agar result nahi aa raha hai to koi dusra reason hoga. Please share file on WhatsApp to understand it. 97081 53000
Bilkul karega. Aap apni file mujhe whatsapp Kar sakte hai? 97081 53000 Detail me janane ke liye ye video dekhiye th-cam.com/video/w-lJ-NvdMlM/w-d-xo.html
One of the best trick. Thankyou sir
Most welcome 🙏
Usefull ! Simple and on point without unnecessary talk ..
Glad it was helpful!
Aye data kaise milega koi bata sakta hain ? Practice karne ke liey.
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
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
sahinkaha bhai ab clear hua
Great Sir ❤ but Sir agr kisi single cell ke data agar search krna hoga to yhi formula apply karna hoga
Yes
Thank you, sir! Was pissed off as couldn't find the exact value for bigger table. Thanks a ton
Most 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
Verry easy explanation
Glad you think so!
Amazing exactly what i was looking for I'll try it , thank you
Most welcome 🙏
Really nice
Thanks a lot
nice explaination 👍
Thank you 😃
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
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
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
this is really amazing, where can we learn all these
It works, excellent
Nice
Thank you so much😊😊😊
Most welcome 🙏
Easy to explain ❤
Glad you think so!
Very good
Thanks
Thank you 👍
You are welcome
Great. इसी फॉर्मूला को खोज रहे थे।
and finally you have it 😊
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 😄.
Thanku sir ❤
Most welcome 😊
Copy paste karke bhi kar sakte hain na sir
Bilkul Kar Sakte Hai 😊
Didn't work this formula. Same type copy only .any one help me
Pls share the file where you applied the formula. Whatsapp @9708153000
Sir ji aap ne tho problem solve kardi meri thank you
It's my pleasure 🙏
Gajab h bhai...
🙏
Nice 👍
Thank you! Cheers!
Sir freeze kaise karte hai bataya neihn
Press function key F4 to freeze
Finally learned vlookup with full clarity ❤❤ concept cleared fully ..thank you 😊
Glad to hear that
Great ❤
👍😊
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! 😊
😊
Sir ager ek sheet m hum quantity likhite hain aur Chahte hain k wo quantity matlab numbers total ho k doosri sheet m ajayein to us k liye Kya karna parega
Sum Function use kariye
@@ExcelUniverse sir thora detail m batayenge plz
Aap Koi Example file mujhe whatsapp par share kariye, 9708153000
Thank u.. i got it.. formula its working 👍
Great 👍
Thank you so much 😊 bhai
Most welcome 😊
Excellent 👌
Thank you! Cheers!
Thanks but how did you freeze the column ?
After selection of range press Function key F4 to fix/freeze
Will it work if I change the order of the column?
Yes
But your lookup column should be first column rest can be change.
Superb...thanks
Welcome 😊
Sir wo screen move hone wali editing konse software mein kri aapne?
Techsmith
@@ExcelUniverse ok thanks
Ise badiya xlookup hai
Yes XLOOKUP is the best function ever, But Ye Sirf Microsoft 365, Office 2021 or Online Excel me hi Hai
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
Thank you bro
Welcome
Column formula se bhi hoga
No, Column Formula Header Ko Match Kar Ke Uski Position Nahi Dega
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 ya sabse easy formula hai
Isase Bhi easy hai LOOKUP Function.🙂
Thank you so very much bro
Happy to help
Sir m vlookup use kr rha hu dusri sheet se to NA error aa rha h plz help me
Pls share your file where you applied formula. Whatsapp 97081 53000
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
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
Sir clolm frezz kese karna padata he
Press function key F4 to fix the range
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
Will try definitely. Great
All the best
Fridge karne se kya hota hai. Ek baar f4 dabane se kya hoga or 2 or 3 bar dabane se. Please reply
th-cam.com/video/xz2G2BkW0qg/w-d-xo.html
Watch this
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
Superb
🙂
Hi...Dear brother...Thank you so mush for this video...God bless you and your family
Most welcome 😊
Vlookup +choose simple rahega jab header same ho aur mai match kyon lagai sirf vlookup se jab kaam ho jayega. Aur bahot logo ko column freeze Karne ka idea nahi hota jisse confusion hota hai value nahi aane pe.
Need to understand
Hi Sir, I didn't know we could apply the formula in all cells at once, however, this didn't work in my Excel. Is there any issue with either my system or any changes in this formula now.
Can you please share file where you applied formula. Whatsapp 97081 53000
Somebudy kindly tell me how to freeze a single cell
Use function key F4
Column freeze kaise krenge?
Press function key F4 to freeze
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.
Screen record ke liye konsa software use kiya apne
Techsmith
Wondershare
PowerPoint
nice
Thanks 😊
Hello sir
I want to know a editing software or app where I can edit my video from landscape to portrait i.e. I want to record my computer screen but in portrait mode or may be after editing it becomes portrait mode.
So is there any free editing software where I can do such editing?
No free software.
But you can try Techsmith, Wondershare
@@ExcelUniverse what's that feature called?
Screen ration 9:16
@@ExcelUniverse sir, what about the moving screen i.e moving mouse with screen?
Kya hum ise 2013 version me use kr sakte he kya ??
बिल्कुल कर सकते हैं
Thank you
You're welcome
Thank you so much
You're most welcome
Copy paste se bhi kar skte kya
Ji Ha Bilkul Kar Sakte Hai
What is the shortcut to freeze the range
Function key F4
It can be also done with fillter
Yes, but it's all only in o365 and o2021
Match ki jagah column formula bhi toh use kar sakte?
Column header ko match kar ke uska number nahi dega.
Agar Koi Column shift hota hai to Column function use karne par uska data v change ho jayega.
Jabki match function pure range header ko match karega chahe wo kahi bhi rahe
@@ExcelUniverse column me bhi toh freeze ho jata hai
MATCH फ़ंक्शन कॉलम की पोजीशन को डायनामिक रूप से खोजने में मदद करता है। अगर आप डेटा को एडजस्ट या बदलते हैं, तो MATCH Function डाटा के हैडर के हिसाब से ऑटोमेटिकली एडजस्ट हो जायेगा।
जबकि COLUMN फ़ंक्शन एक फिक्स्ड नंबर देता है। अगर आपके डेटा में कॉलम्स एडजस्ट होते हैं, तो आपको मैन्युअली COLUMN नंबर को भी एडजस्ट करना पड़ेगा।
th-cam.com/video/K1ZMmcRFuto/w-d-xo.html
th-cam.com/video/w-lJ-NvdMlM/w-d-xo.html
th-cam.com/video/eJNIGfZ6Hq0/w-d-xo.html
formula lagate huve colum freeze kaise kare
Press function key F4
=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
Thank you so much, this helped me a lot!!!
Glad it helped!
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
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
Thanks alot ❤
Most welcome 🙏
Great 🎉
😊
Mera kyu ni work kar raha is formula se.
Please share the file where you applied formula. Whatsapp at 97081 53000
Thank you sir
Most welcome
Bhai applying vlookup on 2nd column for name is easy and quick and just copy paste to the next column.
😊
अगर main list में एक employee id के एक से ज्यादा रिकॉर्ड हो। मतलब main list में एक employee id कई बार रिपीट हो रही हो तो क्या data show होगा?
लिस्ट में जो सबसे ऊपर होगा उसी का रिकार्ड आएगा। VLOOKU, HLOOKUP, MATCH,L और INDEX सभी functions इसी तरह काम करते है।
How to match 2 tables, how to find differences in 2 sheets
Use consolidated option, given in data tab
Apne ye to btaya nhi kitni bar kaha pe fridge krna h jldi jldi me vdo bana d kitni problm hori h ab।।। Same cheej ek bar done ho gya but dobara problm shuru ho gyi
You need to know why and when need to freeze cells or range.
Visit on the channel to know more
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.
Thank sir ❤ reply bhi aapne bhot fast Diya Thaku sir🙏
😊
Sir ctrl + entre press karne se bhi pura data nahi aa raha kya mistake ho raha please reply kijiye
Ctrl+Enter sirf copy karne ke liye use Kiya gaya Hai.
Agar result nahi aa raha hai to koi dusra reason hoga.
Please share file on WhatsApp to understand it.
97081 53000
Bhai krke dikha rha h yaa sikha rha h ..
Because jo speed or lack of proper information h uski vjh se kuch smj nhi aaya
Pura Video Dekhne ke liye clik on the link
th-cam.com/video/w-lJ-NvdMlM/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
Thank you so much sir
Most welcome 🙏
Thanx Sir.....❤️
Most welcome
Freeze kaise krege pls bta do😢😢
Press function key F4 to freeze
Freeze kisse Krna h
Press Function key F4 to freeze
सर जी, अलग अलग शीट मे ये फॉर्म्युला काम नही कर रहा है...
क्या करे?
Bilkul karega.
Aap apni file mujhe whatsapp Kar sakte hai? 97081 53000
Detail me janane ke liye ye video dekhiye
th-cam.com/video/w-lJ-NvdMlM/w-d-xo.html
Bhai ye columbfreeze kse krte h
Press function key F4 to freeze cell
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
Sir aap freeze kese Kiya?
Function key F4 press kar ke
@@ExcelUniverse ok thank you sir😊
Range ko select kaisai krna h...
Keyboard ya mouse se
Thanks
Welcome
@@ExcelUniverse can xlookup do all things what can vlookup do
Yes but it's available in office 364 or 2021 only