निवेदन है की आप जो डाटा यूज करते है उसको भी अपलोड कर दिया करे जिससे हम उसको डाउनलोड करके प्रैक्टिस कर सके बाकी आपका तरीका बहुत बेहतरीन लगा , आपका पहला वीडियो देखा है अच्छा लगा। धन्यवाद
Bahut achhe tarah se koi bhi topic samjhate hai aap.thanks Ager 2022 me employees ki sankhya increase ho 2021 ki tulana me aur 2024 me employees ghatkar jae 2021 se 2023 ki tulana me to us condition me kaun si table ko value denge Aur yadi 2024 me nae employees jude jinka naam pichale years me na ho to fir kya karna hoga
Sir please is topic par ek video bana dijiye. Sir mere paas excel ki ek sheet hai jisme 1 month ka bahut bada data hai, jisme bahut sare bill no same hai lekin amount different hai, mujhe aise report banani hai use match karne ke liye, ki sare same bill no wale ka total amount show ho jaye. & Sare sheet pe apply ho jaye. Sir please reply kijiyega
सर एक विडियो में बताईए की जिस कम्पनी में data entry karne ko kaise aata hai aur usme email ya document me aur kya kya us data me se enter karna hota hai
Sir excell formula se bhara hua hain kitna formula yad rakhu .. koi aisa tricks hai ki kam karte karte jaisa problem aya bina formula yad rakhe kar pau
Instead of manually changing formulas for other three columns use {2,3,4,5} must be in curly brackets. This is the formula i used on my data: =VLOOKUP($E$8,SWITCH($L$5,2021,Table1,2022,Table2,2023,Table3),{2,3,4,5},0)
Sir factory ma football banay jaty hai on ko computer par scane kar KY bad ma btana Hota hai kis ny kitny football banay hai asi koi video hai tu plz link send kar dy 🙏🙏🙏
Ye bekar ka function use karke time waste mat Karo is case main sidha table ka name hi change karde for ex- Yr2021,Yr2022 then use it as vlookup table name 🦄🧐
Sir agar 4 sheet ka data hai aur us subhi data ko 1 hi sheet mai merge krna hai toh wo kaise kre vstack ka use krte hai but samgh ni aya pls jaldi video bna ke dale hamara interview hone wala hai
![Advance Filter on Large Data in Excel | Filter vs VLOOKUP | [Hindi] #excel](http://i.ytimg.com/vi/U_pj0V5EOm4/mqdefault.jpg)
![Interview Questions & Answer for Excel | excel interview questions [Hindi]](http://i.ytimg.com/vi/UOjcv1Ul3oI/mqdefault.jpg)
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](/img/n.gif)
निवेदन है की आप जो डाटा यूज करते है उसको भी अपलोड कर दिया करे जिससे हम उसको डाउनलोड करके प्रैक्टिस कर सके बाकी आपका तरीका बहुत बेहतरीन लगा , आपका पहला वीडियो देखा है अच्छा लगा। धन्यवाद
बहुत ही आसान तरीके से समझाया । धन्यवाद ।😊
Sir Mai ne der sare teacher deke lekn AP jaisa Mai heran ho sir apki teaching bahut zabrdast hai ❤❤❤
What an tremendous lecture.... Just waooooooo 😮😮😮
Bahut accha laga aapki video dekhne ke bad or samaj mai bhi aa gya hai.
Very informative , Thank you. Will it be possible for you to share this excel sheet to practice ?
thank you sir nicly explained
Nicey ❤❤ learning to students
Thanks Jani..... 🎉 very helpful video ❤
sir...match k bajay coloum ko bhi use ke skte hain.
easily learned , lot of thanks from Nepal
Thannks sir Muje aap se proper excel sikhna hai aap se pls help me
Bahut achhe tarah se koi bhi topic samjhate hai aap.thanks
Ager 2022 me employees ki sankhya increase ho 2021 ki tulana me aur 2024 me employees ghatkar jae 2021 se 2023 ki tulana me to us condition me kaun si table ko value denge
Aur yadi 2024 me nae employees jude jinka naam pichale years me na ho to fir kya karna hoga
Iam big fan sir from Pakistan,❤
amazing video sir,but sir also provide pratice sheet for pratice
It was really amazing 😊😊 god bless u
Amazing video sir❤
Amazing tutorial.❤
Informative video sir ❤👍
Thank you sir
Very nice good 👍
Agar colums ke liye {2,3,4},0 se hoga?
Sir please is topic par ek video bana dijiye.
Sir mere paas excel ki ek sheet hai jisme 1 month ka bahut bada data hai, jisme bahut sare bill no same hai lekin amount different hai, mujhe aise report banani hai use match karne ke liye, ki sare same bill no wale ka total amount show ho jaye.
& Sare sheet pe apply ho jaye. Sir please reply kijiyega
Sir All amazing video 😊
Very nice sir
Very nice
Amazing brother
Useful video sir. 🙏
V.good sir
Nice❤
Bhai kya hum loag is formula ko use karke total karsakte ho kya?
Thank you sir 🙏🙏🙏
Can I use this for Google sheets??
Bhai super yr soo amezing
Achche teacher bahut hi kam he face to face padhne par.😐😶🥴
We can use IFS condition ?
Vlookup and indirect se bhi kar skte hai
Very nice sir 👍
Hello mam
Great sir
Please provide the dataset sir
Nice
सर एक विडियो में बताईए की जिस कम्पनी में data entry karne ko kaise aata hai aur usme email ya document me aur kya kya us data me se enter karna hota hai
Excellent bro
Bank statement excel pe kease entry kare sir
Pls provide dataset sir🎉🎉❤❤
Sir plz aapse request hai ki aap ek video esi or banao ki ek sheet m ek name two times hai to us pr vlookup kaise use karna hai
By Id
Maine ye sb vlookup bhi kiya hai
Acha hai
First view
Sir excell formula se bhara hua hain kitna formula yad rakhu .. koi aisa tricks hai ki kam karte karte jaisa problem aya bina formula yad rakhe kar pau
Bhai please sath me practice file bhi share kar diya kro 🙏
MySQL pr video banao bro please...
Thanks
Hello sir if switch function is not working what will we do?
Sir ye work (xlookup) sy nai ho skta kindly explain this
❤❤❤
Can you share link for website.I searched it its not opening
Sir excel ka all class sir
Practice के लिए data sheet provide करना चाहिए आपको
How to view full data without dropdown in the master sheet
Bhai agr headers aage piche ho?
With the help of AI bhi btaiye , how to work in excel with the help of chat gpt
Sir why my all columns automatic change in formula..how to delete this formula in vlookup.and my laptop.
Rather than making table one by one.........we can use macro
Instead of manually changing formulas for other three columns use {2,3,4,5} must be in curly brackets.
This is the formula i used on my data:
=VLOOKUP($E$8,SWITCH($L$5,2021,Table1,2022,Table2,2023,Table3),{2,3,4,5},0)
Sir Excel mai Swich formula hi nahi aa raha kya kare
Sir pls provide practice sheet
Sir attendance sheet ko bie vlookup me ke se dekhe
Sir worksheet de dete toh practice ho jaati
Khud bhi bana skta hai.... Vo to tu bhai, it' easy
Sir switch formula is not able to accept in my pc please need help
Sir factory ma football banay jaty hai on ko computer par scane kar KY bad ma btana Hota hai kis ny kitny football banay hai asi koi video hai tu plz link send kar dy 🙏🙏🙏
Ya Kam mil Raha ha magar itna knowledge nai hai plz guide 🙏🙏🙏
What is ur website name
Sir practice file link share kr diya kro please 🙏🙏🙏🙏🙏🙏
Sar KIS app per padhaate Ho
Switch ki jgh indirect function?
Sir resume wale video me apne 0.5 margin lene ko kaha jab border me colour krre hai to wo bahar jara h plzz tell kya hua h
Nerro mergin kar liya karo page setup k group se.
Bina practice file ke ye video hamare kis kam ka???
Sir G training file bhi diya kro
sahi kaha brother 👍
Itna to khood hi bana sakte h😂
how can i download the data sheet?
Mera Switch function Kam nehi kar Raha hai 2016 me
Sir video ti thik hai lekin aap file diya kro
Koi video h to please link
SWITCH FUNCTION WORK NI KR RAHA HAI BROO
Are sir. Excle me to switch function aahi nhi rhaa
not working on switch on validation
Bhai agar name se hi pura data nikalna he to kese kre
practice file
sir practice file do
Ye bekar ka function use karke time waste mat Karo is case main sidha table ka name hi change karde for ex- Yr2021,Yr2022 then use it as vlookup table name 🦄🧐
Switch formula hi Nahi hain excel main
😂😂😂😂😂😂😂dimag ka dahi kar diya bhai, Excel aasan banana hai
Muskil nahi 😂
Lol use curly braces for references it is one at a go
Sir agar 4 sheet ka data hai aur us subhi data ko 1 hi sheet mai merge krna hai toh wo kaise kre vstack ka use krte hai but samgh ni aya pls jaldi video bna ke dale hamara interview hone wala hai
Thank You Sir