Vlookup with Match formula in Excel | Hindi

  Рет қаралды 152,738

Excel Superstar

Excel Superstar

Күн бұрын

Пікірлер
@ExcelSuperstar
@ExcelSuperstar 4 жыл бұрын
Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20* Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
@anshumanrai4151
@anshumanrai4151 5 жыл бұрын
🙏🙏...Sir man gye ye kam sirf Excel super star ke bs ka hai✌✌
@goldiyadav2784
@goldiyadav2784 4 жыл бұрын
Wow superb sir... thanks a lot ..it's very useful for us.
@cmokorangi7945
@cmokorangi7945 5 жыл бұрын
Very Nice You have resolved my problem Thanks
@saquibsher
@saquibsher 5 жыл бұрын
u r really a supper star ... very well and clear explanation...100/100 thumb up
@nitinladke2448
@nitinladke2448 6 жыл бұрын
Dear wrushab ur all videos are superb. I seen more than 100 videos it is very helpful thank you. Your teaching also very creative & simple to understand everyone. Keep it up.
@justice853
@justice853 5 жыл бұрын
Sir mai daily is tarah 1 sheete 2 2 vlookup lagata hu aapke is formule se mera kam bahut easy ho jayega thanx sir ji
@TravelAdventure-India
@TravelAdventure-India 3 жыл бұрын
Good Illustration Sir
@shruthikumar3107
@shruthikumar3107 4 жыл бұрын
Aweosme sir,this is what I was looking for and I use such data everyday.Thank you so much.
@sohailkhan-yz7sc
@sohailkhan-yz7sc 5 жыл бұрын
give some problems so that we can practice in pdf or in description in a small format. over all excellent and thank you for this use full info.
@someshkalaskar4367
@someshkalaskar4367 5 жыл бұрын
Thank you sir ji. I am waiting that type of video finally got it thank you for this video 🙏
@manmohandeol4908
@manmohandeol4908 7 жыл бұрын
R. Sir, Very interesting, simple way to describe thanks for sharing this.i am fan of your channel. I suggest you please make a video that when we click in a cell whole row and column line will be highlighted.it may helpful in the maintain of large data correctly. Thank Manmohan.
@SurenderGatt
@SurenderGatt 6 жыл бұрын
way of explanation is so good. 👌👌👌👌👍👍👍👍
@krishna2241
@krishna2241 8 жыл бұрын
ye to abhi suruaat hai boss. aage bahut like milenge thank you
@rajeshdebnath8673
@rajeshdebnath8673 7 жыл бұрын
As your Voice your coaching is superb
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
बहुत बहुत शुक्रिया सर
@sweet178ful
@sweet178ful 6 жыл бұрын
Its is very Help full for me !!! Thank you so much
@RohitSingh-pw2or
@RohitSingh-pw2or 6 жыл бұрын
your way of talking is awesome
@mahabirupadhyay9730
@mahabirupadhyay9730 3 жыл бұрын
You are real superstar
@birenray7630
@birenray7630 4 жыл бұрын
So so thank you sir .. It help me a lot..
@kiransati3508
@kiransati3508 5 жыл бұрын
Thanks for learning sir ...
@MC-io4fg
@MC-io4fg 4 жыл бұрын
Please, make single video of ur 5 favorite excel formula .
@jafarhussain6606
@jafarhussain6606 5 жыл бұрын
Perfect. Thank you very much
@kumarsaurabh2614
@kumarsaurabh2614 8 жыл бұрын
hi sir your all videos are excellent can u plz guide me how i can bifurcate intraday and delivery share transaction in excel
@rishabhpugalia9281
@rishabhpugalia9281 8 жыл бұрын
send sample file to hello @ yodalearning . com
@LakhanSingh-ns2je
@LakhanSingh-ns2je 7 жыл бұрын
Thanks a lot, Rishabh Sir..... I learnt a lot from your channel.... Your every video is excellent... 👍👍
@basheershafi3103
@basheershafi3103 6 жыл бұрын
Thank you brother. Excellent teaching.
@tinkushukla6891
@tinkushukla6891 5 жыл бұрын
You are awesome sir
@miss.rogekhan3098
@miss.rogekhan3098 2 жыл бұрын
dear superb but kindly instruct us regarding f4 key how to use that
@RMKserve
@RMKserve 3 жыл бұрын
No doubt super♥️♥️❤️
@krishankumar-bl1he
@krishankumar-bl1he 3 жыл бұрын
Hi I was using this function to match 2A & Books, however its always collect same invoices of diff parties.
@mj.912
@mj.912 5 жыл бұрын
Superb gurujiiii
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
Superb sir great
@mrsaharamesh
@mrsaharamesh 3 жыл бұрын
I need help. Is there any formo in this same sheet so that if we edit in second sheet it will directly get edited in main sheet
@healthwealthbynutrition6858
@healthwealthbynutrition6858 5 жыл бұрын
Thanks sar....you are genius...
@mahaboobhossain5076
@mahaboobhossain5076 5 жыл бұрын
I LIKED THE VIDEO VIJAAAAAAN
@allforedandtech
@allforedandtech 3 жыл бұрын
Really Super...
@VICKYROMEO786
@VICKYROMEO786 6 жыл бұрын
thx for teaching this cool combination of excel formula
@AnsarKhan-cg1uc
@AnsarKhan-cg1uc 5 жыл бұрын
Hi Rishbh Ji you are great tutor, can you please upload video on Reconciliation client! I am having definitely to reconcile huge data
@gujran8008
@gujran8008 6 жыл бұрын
आपका पढना तरीका बहुत अच्छा है इसके अतिरिक्त आप और विडियो बनाओ
@MrPreetampandey
@MrPreetampandey 5 жыл бұрын
Thank you sir pls add a video how to calculate GST on MRP in sales
@priyesh3464
@priyesh3464 5 жыл бұрын
Sir , will you please make a video on mail merge with extract individual data and send to different recipients....., please
@zainshah2827
@zainshah2827 3 жыл бұрын
Sir kindly Aap har video kay sath practice file bhi share kia karain takay hum in formulas ko khud practise kr kay behtar tariqay say smajh sakain
@ExcelSuperstar
@ExcelSuperstar 7 жыл бұрын
Advanced Excel Webinar v2.0 Hurry up! Book your seats now(limited seats) www.excelsuperstar.org/
@muhammadjaved5131
@muhammadjaved5131 5 жыл бұрын
Love U Sir Much Informative
@insight_vision_
@insight_vision_ 6 жыл бұрын
Very helpful, thank you sir
@satyajay8276
@satyajay8276 8 жыл бұрын
great work buddy...thank you...!
@travelingplacesinnepal8467
@travelingplacesinnepal8467 4 жыл бұрын
Sir g ye formula se yek work sheet se dosra work sheet m use nahi hota h?
@preeteshdoshi4035
@preeteshdoshi4035 5 жыл бұрын
hi rushabh, can u hep me on my query i have date in col "b" and code in col "c" and which data i want its in col "r" and its in text format which function should i use to fatch a text from col "r" like if my date is 22-8-19 and code is "acc" , result should be from col "r" is " long" same as if my date is 23-8-19 and code is "acc" , result should be from col "r" is " short" same as if my date is 22-8-19 and code is "tcs" , result should be from col "r" is " short" same as if my date is 23-8-19 and code is "tcs" , result should be from col "r" is " short cover"
@rahulkumar-sq7lv
@rahulkumar-sq7lv 4 жыл бұрын
Ek no bhai
@shubhrasharma6370
@shubhrasharma6370 7 жыл бұрын
Yaar You are great!
@sanjaysaini4730
@sanjaysaini4730 5 жыл бұрын
Thanks Sir.....
@ULLODHI
@ULLODHI 4 жыл бұрын
how to conclude data from different work sheet (same work book) to an other sheet in same work book (summery sheet) without repeating the formula (vertical as well as horizontal) . Is it possible ?
@arijeetkumarsharma226
@arijeetkumarsharma226 6 жыл бұрын
Super se upar.
@balamira297
@balamira297 4 жыл бұрын
wow the best!
@kraaj9556
@kraaj9556 6 жыл бұрын
Superb..
@mrmastermind84
@mrmastermind84 6 жыл бұрын
Excellent Great Work
@Somenath05
@Somenath05 6 жыл бұрын
Great...Bro...
@milanmandaliya899
@milanmandaliya899 7 жыл бұрын
plz. make video of full home tab.insert tab and so on which is more helpful to us
@ahsanulrafi
@ahsanulrafi 3 жыл бұрын
bohot pasand aya
@vinay103
@vinay103 6 жыл бұрын
Super!!
@javedali230
@javedali230 7 жыл бұрын
great job sir
@sunilkotyan4443
@sunilkotyan4443 5 жыл бұрын
Super...
@amit53316
@amit53316 7 жыл бұрын
thanks a lot can you plz give me idea abot index
@greywings93
@greywings93 3 жыл бұрын
Amazing
@sohailkhan-yz7sc
@sohailkhan-yz7sc 5 жыл бұрын
and bhai while doing match function its giving wrong info some time and some times NA as an error( value not found)... would you please help me out for resolving this issue.
@satenderkumar6111
@satenderkumar6111 6 жыл бұрын
Sir Hum isko index formula se bhi kya kar sakte
@SonuSharma-qz9qi
@SonuSharma-qz9qi 6 жыл бұрын
Thanks you for this formula
@mubashirhaseebansari5059
@mubashirhaseebansari5059 5 жыл бұрын
how to compare two sheets like CNIC number
@MuhammadSajidd
@MuhammadSajidd 5 жыл бұрын
very helpful
@PhysicWorld9847
@PhysicWorld9847 5 жыл бұрын
hello sir make a video on macros function with full explanation sir .
@venkatbabu5866
@venkatbabu5866 6 жыл бұрын
Thanks a lot.
@neerajkandwal2708
@neerajkandwal2708 4 жыл бұрын
How we can download the excel sheet
@radhepandit1378
@radhepandit1378 6 жыл бұрын
Very nice sir
@archanaaa2514
@archanaaa2514 5 жыл бұрын
Sir is we need to obtain a excel course for job? Or can we go ahead with excel knowledge?
@sandeepmoolya8384
@sandeepmoolya8384 4 жыл бұрын
How to use vlookup with match formula in two different excel?
@bhilvasant3686
@bhilvasant3686 3 жыл бұрын
Very good nice 👌 But hare columns me group ho to filter kise kare?🙄 Me JioMart me work karta hu Daily 1500 orders ate he sara kam Excel throw hota he but articles 2500 he. Category list he VLookup se scan karte he open kitne he duplicate kit ne he. Muje columns me groups bane he Fnv,food, staple .. Group me sub details he but use filters kise karu ? VLookup se Please help..
@maheshdevtarse8056
@maheshdevtarse8056 5 жыл бұрын
Awesome
@begnasonline8299
@begnasonline8299 7 жыл бұрын
Dear sir I need following formula please guide me. In: ‘A1’ I will type this (2000*1)+(60*4)+(200*6)+(300+150)*2 (i will type all data in this cell without = because after enter i need visible this text.) so we need to add = in A2 cell with formula. The total of above is 4340 I want result in A2 with above total 4340*00.45= 19.53
@Monusingh-xi4vc
@Monusingh-xi4vc 3 жыл бұрын
Prectice file?
@pankajsharma9996
@pankajsharma9996 6 жыл бұрын
Super👍
@ahmedhyd867
@ahmedhyd867 7 жыл бұрын
Hello Sir, very well explained all about Vlookup, Kindly upload tutorial how to combine forecast,match and index to be used as to interpolate in between values of two or more columns or any other method if you feel possible.............Thanks
@kingvlogbd
@kingvlogbd 5 жыл бұрын
vai ma to formula to dadeya lakin nahe ho taha ku?
@suniltripathi0809
@suniltripathi0809 2 жыл бұрын
Super
@vipulsharma811
@vipulsharma811 6 жыл бұрын
Super sir
@ramiz.chowdhury
@ramiz.chowdhury 3 жыл бұрын
Sir... Vlookup + Match formula hum different workbooks/file se kaise kare... Bahot paresan hu sir.. pls make a separate video for this. I can apply this formula in same sheet but facing problem with different workbooks|excel file.. pls help sir
@rohitnegi3362
@rohitnegi3362 7 жыл бұрын
grt work yaar keep going
@harishbisht737
@harishbisht737 6 жыл бұрын
Great
@jamruddin
@jamruddin 5 жыл бұрын
sir formula toh work kar raha hai but aagar mein master sheet kuch change karda hoon toh jis sheet me mein formula laga hai waha kuch change nahi ho raha hai please help me sir
@KoushikKarmakar2904
@KoushikKarmakar2904 6 жыл бұрын
Could you please make a tutorial of how to create word file from excel without mail merge function ?
@KoushikKarmakar2904
@KoushikKarmakar2904 6 жыл бұрын
Superb
@anshumanrai4151
@anshumanrai4151 5 жыл бұрын
Thnq sir
@radhepandit1378
@radhepandit1378 6 жыл бұрын
Sir SAP ke videos btao SAP ke bare me jankari de sakte ho sir
@hirendrashriwas8021
@hirendrashriwas8021 2 жыл бұрын
Sir pls will you give this formula in comment section🙏
@lalitkumarsharma1493
@lalitkumarsharma1493 6 жыл бұрын
Kise worksheet m sheet 1 m Kuch data tha usme se Kuch data sahi Ho gya h or galti se vh delete Ho gya phir bhi Harare pass bh DATA h jo sahi kiya tha bh hame khi se milta h to sheet 2 m sahi DATA h or sheet 2 m sahi galat dono DATA h to hame sheet 1 m sahi jo kiye h bh kaise mark kre please send me video sir
@usmanchaudhri148
@usmanchaudhri148 2 жыл бұрын
Supppperrr sirr
@VijayPaaswan-30
@VijayPaaswan-30 7 ай бұрын
Wow 😲
@bucketlist5962
@bucketlist5962 5 жыл бұрын
Woh f4 karke doller atta hai ....woh wala vedio link dijiye na muzhe
@FORYOU-wb1rx
@FORYOU-wb1rx 6 жыл бұрын
how to keep last bottom two row always visible in excel
@msivakumar1214
@msivakumar1214 6 жыл бұрын
Super bro
@karanshukla995
@karanshukla995 5 жыл бұрын
I need help bro can you
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
ROUNDUP & ROUNDDOWN Basics 02 - Round off numbers in Excel | Hindi
2:43
Excel Lookup Formulas: Lookup vs VLookup vs HLookup vs Match
8:50
Excel Superstar
Рет қаралды 209 М.
Мясо вегана? 🧐 @Whatthefshow
01:01
История одного вокалиста
Рет қаралды 7 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
IL'HAN - Qalqam | Official Music Video
03:17
Ilhan Ihsanov
Рет қаралды 700 М.
It works #beatbox #tiktok
00:34
BeatboxJCOP
Рет қаралды 41 МЛН
MS Excel - 7 reasons for #N/A error in VLOOKUP [How to FIX]
11:23
Excel Superstar
Рет қаралды 75 М.
Match function with VLookup formula in Excel | Part 1 | Hindi
6:45
Excel Superstar
Рет қаралды 134 М.
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,8 МЛН
What Xlookup Can Do For You ? Xlookup Tutorial - Xlookup in Excel in Hindi
29:23
Double Vlookup | Double Vlookup Formula in Excel | Hindi
7:37
Excel Superstar
Рет қаралды 133 М.
Vlookup with Match in Excel 2019 Hindi
6:40
My E-Lesson
Рет қаралды 38 М.
Мясо вегана? 🧐 @Whatthefshow
01:01
История одного вокалиста
Рет қаралды 7 МЛН