I had requested you make a video for ordering goods to my company, where I have to choose from many products. And it was tiresome to write name, weight, rate every time according to the product. By your this lookup method my problem is solved. I am using this trick. Thank you very much.
Very good information sirji But aapne is data me first column khali rakha hai..aapke dusre Kai videos dekhe vlookup vale usme bhi data k first column khali rakha he.. Kya data ka first column khali rakhna compulsary hai ya koi aur reason hai? Waiting 4 Reply..
Hi Deepak sir, sir jab mein vlookup formula lagata hu uske baad look value change karta hu toh vlookup formula kam nahi karta Aisa Kyu... Plz plz sir jaroor batana I will wait sir
I have a multiple sheets in excel Aur meine warehouse map banaya ha , mein chahta hun ki kis rack mein kaunsa maal rakha ha aur kitna rakha ha .. yeh mujhe pata chale , woh kaise kar sakte ha ? Can you help me in that
Sir, I have 5 accounts (Eaxm-A, B, C, D, E), they have separate sheet entries, I want to see the account of any month, any day of those 5 accounts (Exm- Deposit, Withdrawn & Interest) . Which will show in a separate sheet 5 Accounts together. How can I see with the help of Vlookup or any other formula?
sir ap is ka formula bata dain k hamary school mn 8 classes an hum un ka result bana rahy han to man chata hoon k uper dropdown bana kar jis class ko select karoon us poori class ka result samny aaje thanks waiting for kind answer
can we give a name or store formula that we use again and again in evey sheet. Just like range data. U told we can save data range in formula then define name for data range.
Jo apke liye asan hota hai wahi upload karte hai jo nahi ata wo nahi karte ho mai kitne bar bola ke ek aisa stock sheet banaeye jisme bacha hua stock automatically next sheet me chala chaye
Sir, data Sheet me se ek he customer ke different product ko invoice m ke se liya jay Ex:- invoice no . 1 , product - dry cell , price - Rs 6 Invoice no select kr ne pr invoice bill me aa jay
sir , mere ko sales pending order mantain kaise kre , mere pass 100 partys hai or 500 products hai or ek proudct kei baar rept hota hai sir koi aeisa formula bataye taki me alg alg party ka panding order mantain ho jaye sb partiyo ko milakar pending proudct summery bhi mantain ho jaye
Vlookup Full Tutorial Basic to Advanced
th-cam.com/video/V4YgQTFLmyc/w-d-xo.html
Hello deepak ji
I have some doubts on vlookup
I want to contact you
Can u plz giv me ur num
I am really thankful for you, man.
बहुत बढ़िया, हर चीज को बारीकी से समझाया जा रहा है। thanks
Bahut ache se samjh m aa Gaya
U r the best in excel......
Tks deepakjee, very useful
I like ur videos..that's are very helpful to all of us..who are preparing excel..a lot of thanks
Sir app bahut aacha samjhate hai thank you so much sir.
Nice Deepak sir
Very nice video sir ji you are great sir ji
😊😍
सर आपका समझने का तरीका बहुत अच्छा है
Just one word for you that is AWESOME
thanks
Best explanation 👏👏
But hma sales, age or department ma alag alag formula lga rha ha but teno ka ek sath bhi lga sakta hai kya?
Thank you sir I got alot of knowledge from your videos ...
Very good
Excellent. I have learnt something for my future videos 😃
Contact number
Nice sir thanks
You are absolutely perfect in thus field i have totally learned from these lectures i even don't how to open excel
Thanks
Very good video
Very nice👌
Thankyou Sir
Thank you sir for your wonderful class❤️
Nice Deepak
Very nice sir
9ic sir bhaut achha laga farmula
NICE SIR KEEP ON .................
I had requested you make a video for ordering goods to my company, where I have to choose from many products. And it was tiresome to write name, weight, rate every time according to the product. By your this lookup method my problem is solved. I am using this trick. Thank you very much.
Gr8 respect sir...yur my idel...
Hi Deepak, Thanks for a valuable information.
Very useful
God bless you.. Thank You..
this is perfect video sir.
nice work
Thank sir.
Also provide practice material
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
*Show Me ♥ By Like Share & Comment*
🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
*𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
Very nice
Great video!
Brother name manager ma ja kr range edit krna ka jarurat ni just range to table ma bna do automat range update hoga. All ur videos are very tricky..
Very good information sirji
But aapne is data me first column khali rakha hai..aapke dusre Kai videos dekhe vlookup vale usme bhi data k first column khali rakha he..
Kya data ka first column khali rakhna compulsary hai ya koi aur reason hai?
Waiting 4 Reply..
A good shortcut for vlookup.
🤗😊
Very Nice Sir
Sir ThAnk yOu apne bhut computer skills badhane me help ke hai sir Vlookup with Match function k sath bataye
Excellent video
thank you good video
Sir vlookup one time lgaye or sab show ho jaye esa kuch ho skta he kya
Sir hum ek baar m hi teeno value nikal skte the
sir isme he agar hame garment sector ki total sales aa jaye vlook up se .. ho jaega kya
Table or range ko select kerte time data bhot jyada hai to kse select kregy??? Any shortcut ki???
Sir plz make a video on sumproduct,vlookup+indirect,vloookup+sumproduct.
great sir
TNX
Sir gst k sath invoice Jo d-mart jase retailers use kartee haii vo banana sikhaooogeee to bahut helpful rahegaaa
Ya sure.. I will teach u shortly
Deepak sir ., Please PowerPoint presentation ke liye v video banye ..
sir please make a video in excel for different size different price but hns code and particular name are same with vlookup .
Suppose hum Agar formula cell ko drag krte hai
To kya vlookup drag ki hui cells pr bhi lagega
Plz grose lon wali video btado k salary mai lon k se katega grose dalary kya banegi
Hi Deepak sir, sir jab mein vlookup formula lagata hu uske baad look value change karta hu toh vlookup formula kam nahi karta Aisa Kyu... Plz plz sir jaroor batana I will wait sir
I have a multiple sheets in excel Aur meine warehouse map banaya ha , mein chahta hun ki kis rack mein kaunsa maal rakha ha aur kitna rakha ha .. yeh mujhe pata chale , woh kaise kar sakte ha ? Can you help me in that
Thank you sooo much sir
Amazing sir...
श्रीमान एक नाम या id के आगे की कई rows या कॉलम के Data को1 एक साथ में vlookup के द्वारा कैसे लाते हैं।
nice video sir
Sir aapke samjane ka tarika bahut hi achha hai. Sirji mera ek exel ka work hai kya mai apko call kar sakta hu?
Sir jaise sabhi ko dikhna ho ek sath to kese kare sir please sir tell me
so nice
Hellow sir 2 sheet ka dada 1 sheet me vlookup eya hlookup kar sakte hay kya.
Inventory Management kaise kre sir
Supp
sir data entry job ke interview me kis type ke questions puchche jate hai Kyaa sir aap bata sakte hai please sir
THANK YOU FOR THIS VIDEO .IF DATA AVAILABLE IN THOUSANDS ROW HOW WE WILL COUNT COLUMN INDEX NUMBER DURING THE FORMULA .
Sir, I have 5 accounts (Eaxm-A, B, C, D, E), they have separate sheet entries, I want to see the account of any month, any day of those 5 accounts (Exm- Deposit, Withdrawn & Interest) . Which will show in a separate sheet 5 Accounts together. How can I see with the help of Vlookup or any other formula?
dear deepak please provide also excel file download link in every vedios
Dear Sir in this data ram is entered two times can we v lookup from name
Thax
Sir vba ko samjhaye plz excel mai
Aisa btaao brother ki vlookup lgaane me ak hi Baar me wo sabhi aajaaye
th-cam.com/video/MUmsiEFY7us/w-d-xo.html
Thank you
Nice
How to dynamically change the table array
sir lookup value me 2 column ka option eksath kaise de sakte hai
th-cam.com/video/pKzfB-EcFVk/w-d-xo.html
Great
Respected sir please make a video in Missing data find with vlookup.
Sure..
good
Deepak sir good evening
Agar kisi data me spelling mistake h to uske vlookup kaise Lagaye ge
Hi Deepak, Can two English words in different column merge into one column ?
Dear, if we use columnar function then no need to type vlookup again and again..
hum conditional formating ko kese use kare ki hamare data ki hum kahi bhi koi changes kare to automatic highligh ho jaye
Sir ram kaa total sale sum vlookup Mai kaarna hai
Sir jo aapne table ko name diya hai wo same sheet par to kaam kar raha hai but dusri sheer par nahi !
Excel version konsa hai
2007
Sir attendance sheet k sath offc login hrs nikalne ka video banaye
I want to extract data between dates in another sheet example 1march to 31march which formula I have to use
sir ap is ka formula bata dain k hamary school mn 8 classes an hum un ka result bana rahy han to man chata hoon k uper dropdown bana kar jis class ko select karoon us poori class ka result samny aaje thanks waiting for kind answer
Okaaayyyy.. Please wait.. I ll publish
can we give a name or store formula that we use again and again in evey sheet. Just like range data. U told we can save data range in formula then define name for data range.
Hi sir please make a video on VLOOKUP with wild characters
Ok g
Jo apke liye asan hota hai wahi upload karte hai jo nahi ata wo nahi karte ho mai kitne bar bola ke ek aisa stock sheet banaeye jisme bacha hua stock automatically next sheet me chala chaye
I ll publish shortly
Sir, data Sheet me se ek he customer ke different product ko invoice m ke se liya jay
Ex:- invoice no . 1 , product - dry cell , price - Rs 6
Invoice no select kr ne pr invoice bill me aa jay
Sir namaskar
Kya kruti Dev 010 font par excel 2007 database bana sakte hai
sir ,
mere ko sales pending order mantain kaise kre , mere pass 100 partys hai or 500 products hai or ek proudct kei baar rept hota hai sir koi aeisa formula bataye taki me alg alg party ka panding order mantain ho jaye sb partiyo ko milakar pending proudct summery bhi mantain ho jaye
How to calculate the retirement date first day of the month to be taken last day of the previous month of the year
Missing Serial Number find kaise kre or find hone k baad unke bich insert krke serial continue krne ka shortcut option kya h.
How to input vlook formulla in lookup value. And show through same lookup value
th-cam.com/video/REBdKbbvwG0/w-d-xo.html