Vlookup with Sumproduct | Hlookup with Sumproduct
Вставка
- Опубліковано 3 жов 2024
- How to use vlookup with Sumproduct in Excel
1. Vlookup with Sumproduct
2. Hlookup with Sumproduct
3. Vlookup with Sum
4. Hlookup with Sum
5. How to use Vlookup and Hlookup with Sum and Sumproduct Function
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Lookup (Beg-Adv)-vhlookupwithsumproduct.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookupfunction#hlookupfunction#Innozant #sumproduct
I have no words for compliment. Thank You so much Sir. I learn Excel very well because of you.
❤️❤️❤️thanks Hassan Sahab for your wonderful appreciation..Happy learning ❤️❤️
wow , very beautiful explanation , with nice ending (for 4000 data ke saath).This felt like , TV episodes ,in which we wait until next week , that what will happened now.Ultimate!!
Thanks Jaishri for such a lovely comment always from you dear,These feedback really motivate me to make amazing Excel and career motivation videos.
Gajab explain kiye Hain bhaiya........ye bahut Acha concept hai.....AUR gajab ki BAAT hai aaj hi mujhey Chahiye tha
Thanks Rabi❤️❤️❤️
Sir abb excel sikhna meri aadat nahin zunoon ban gaya hai aur wajah aap ho thanks sir for valuable content bhagwaan aapko lambi Umar aur acchi sehat pardan kare 🙏🙏🙏
Thanks Pawan Ji .God bless You dear..Have a blooming career ahead
Excellent, truely saying you are the king of logic, how & where, you better know use of excel weapon. thanx sir, God Bless You
Love you Salil for.such a 😍 lovely appreciation..God bless you..
Great video sir, you always gave us different different types of knowledge which is very useful for us.
Thanks Hemant Ji,Hope yoi learn the concept and able to implement the seme.Happy learning
Very well explained. You are truly a gem my friend.
Thanks Vikas Ji
प्रणाम सर जी | Vlookup with Sumproduct से मैने आज नई चीज़ सिखी और प्रैक्टिस भी करता जाता हूँ | लास्ट मै आपने जो बोला है 4000 डेटा वाला वो मै सीखने का बहुत इच्छुक हूँ | मुझे एक्सेल सीखने मै मजा आरा है और ये मेरा लाइफ का जूनून बन गया है | भगवान आपको हमेशा खूब तरिकी दे |
धन्यवाद और साथ ही आपके पढ़ने के प्रति लगन प्रशंशनीय हैं
THANKS A LOT SIR, FOR YOUR EXCELLENT EXPLANATION AND JOB ORIENTED EXCEL SOLUTIONS
Good evening sir your video content is fabulous specially vlookup series, easily understand and do practice, growing my skills, great job sir, almost my doubts are cleared.
Happy learning
Very Helpful Video Sir Thanks
Sir you are brilliant. Kiya khubsurati sy smajhaty hain
Zabardast sir
Thanks for your Love and Support Zahid Sahab.. Really means a lot to me.Happy Learning..
Very interesting session guru ji 🙏💯👍👍👍👍💯💯💯
Sir 4000 row wala kaise karege.... Ya to sabka range ka nam define karke... Fir indirect karke... Yahi ho skta hai fir sum kar do hena baki pls batana
Again good content delivered Sirji🙌👌🙏😊
So simple discribe ..
Great..
Love you sir your videos helped me a lot
Bahut khub🔥
very great sir
very beautiful explanation , in the ending (for 4000 data ke saath) how will do this ? plz share the link
excellent video. But i've many rows and waiting for the next video to solve this issue
Kindly watch complete series ,you wonf face any doubts dear
@@Innozant thank you, but if you can give me direct link of your video then i can take help from that video and can submit my report on this Saturday.
Your videos was awesome
Thanks Zubair .Happy learning ❤️
My name is Zubair Ali from Pakistan I am the biggest fan of you
Thanks Zubair sahab.Really means a lot to me ❤️
Match lagayege agar 4000 coloumn ya row hongay to.
sir thank u for adding value in our life......sir is particular question me humne jo array static range diya uske badle dynamic dena chahe to wo kaise hoga please reply sir thank u.
Range ko dynamic karna hai to phir offset ke saath jayenge
Choose ke through Array nahi diya ja sakta hai sir isme?Sir isme SUMPRODUCT kaise apply kar sakte hain , kyunki aap ne bataya hai ki multiple array ho to SUMPRODUCT pehle multiply karega phir sum karega , par ussey toh output badal jayega!!!
Sir if there is large set of row or column then what should I do because creating array not practical
Sir, 6:58 par ctrl shift enter bina solution nikl jayega
I need to take knowledge about if or and if and conditions
some formula missing under your image sir please check once
Wonderful 👍 sir you are too super....sir please tell me. Next video solution with . When will realise?
I am so excited. Next part .
Thanks Mohit Ji.God bless You dear❤️❤️
Maja aa gya sir
❤️❤️❤️ Thanks
Sir what we do for thousands rows and columns
Watch more videos of this series ,you will get your answer
Sir agar 4000 row ya Colam me liye first helper colam me 1 to 4000 number likhna he . Fir uska name range Dena he ,1 cell me name range ka name likhenge . Uske bad sumprodact(vlookup( lookup value,tabal array,indirect(cell name range),0))
Sir mane ase try kiya he
Acha attempt kiya👍👍❤️
@@Innozant thanks sir
= SUM ( INDEX ( data , 0, MATCH ( lookup_value, headers, 0)))
Thnq sir so much thnq
Thanks Gaurav,Share and Support 👍🙏❤️
Data bada ho to range kaise denge
Sir , Aarey ki jagah match function bhi laga sakte the na
Haan..❤️
Very nice
Thanks dear😊
SIR CAN U POST SOME CONTENT, ACCOUNTING USE IN EXCEL
Yes sure Anurag..Will post the same
Sir please make a series on VBA coding in excel
After power series
Sir 4000 rown and col k lie video banaiye
Kya banana hai btaiye..will make videos for the same
Sir make on SQL videos
Noted
Hello Sir ..The concept is clear..However, when Iam applying exact formula as you did,the result iam getting is 0...I recheked and the formula is exactly the same and correct..Where could be the error?Can you please help me with that
Check your data set Mounika ..May be you are doing minor mistakes
सर अगले 4000 row या colom वाला वीडियो नही मिल रहा है कृपया link send करो please
वैसे ये concept तो clear हो गया है 🙏🙏🙏🙏
Kisi Interview cracker me karaya hai ques
@@Innozant सर बहुत समय से 4000 रो या कालम का concept search कर रहा हु नही मिल रहा है please link शेयर कर दीजीए 🙏🙏🙏
= SUM ( INDEX ( data , 0, MATCH ( lookup_value, headers, 0)))
Goodevening sir,
Sir esme tabel array ko lock kyu ni kiya ?
Kahan para Priyanka .may b miss kr diya hoga.dear..table array krna cgaiye freeze
Sir please 4000 row wala batayen
Aage index series me hoga video ..aise yaad nhi hai kaunsa video hoga
Nice
Thanks Zuber
Sir if fuction ke sath wild card ka video banaiya
Hoga sayad iske upar video..ok alagse bhi bnate h
Nice Sir, I do.
Good👍🙏❤️
sir plz tel me where is another video for solution of 4000 rows?
Index series me hai available
@@Innozantvideo link please share Karo
Sir, vedio time at 7:20 enter use कर सकते है
group ka case nhi hoga to kyu nhi
Sir i have a question. I have data in five sheet in same formate and i want the value of column no. 2 by vlookup how can i use use all this five sheet as a array in vlookup
It's is simple approach..You may share your excel sheet with query explanation.Will try to give you solution for the same
Okay i will send
Sir, How can show 3rd bracket or array
Like what output you are looking for?
Sir is video k end m jo sawal tha vhi same mra question hai to is video k next part video ka link share krdo
Sequnce me dekhte jain mil jayega jawab
Sir agar jayda row ho toh kasie hoga
To bhi kya isssue h
@@Innozant vlookup se column se kar rha tha usme ho nhi rha h sir hlookup se hogya Sir
❤
sir is question ka best solution kya hoga jo apne is video me nhi btaya.
Index series me h solution
@@Innozant ok
Thank you sir
❤️
Sir, could you help us by giving the answer on the query raised.
How to sum, if the cells are 4000. Please suggest
Whats problem you are facing while asd the no. Of cells?
= SUM ( INDEX ( data , 0, MATCH ( lookup_value, headers, 0)))
Can I ask u some thing?
Sure Zibair sahab
Hi can you share link of next vedio this series
Kindly find playlist for Lookup function..all videos are there in sequence 58 plus vise are there for vlookup only
🙏
Please share the link of next video
Complete playlist of lookup and reference function are there mmplese follow step by step
Where the complete playlist please share
Where is the just next video of Su product and vlookup
Sir tried but not getting it
What happen
Uska next video name pls, jis main sum of unknown row & column( dynamic)
kaunsa video
4000 row or or 4000 col hoten toh kei se karenge sir
Sir is video me jo apne question kiya hai us question ko solve karne ka jo video banaya hai uski link send kar dejeya pls
Solution isi video me btaya hoga na.
Nahi btaya hai solution isme
sir we can use {=SUM(VLOOKUP(B23,B18:I21,COLUMN(E1:H1),0))} column function instead of {5,6,7,8} to pass array if i am right plz reply me
= SUM ( INDEX ( data , 0, MATCH ( lookup_value, headers, 0)))
You checked it.. it's working ?
You checked it.. Working ?
can u send me complete formula for adding multiple column or 4000 column
@@Innozantplease dhare complete formula to add 4000 columns.
Sir kara do pls 4000 rows wala
sir 4000 row wala pls kra do pls
ok..sahi yaad delaye..nikalta hu time..
@@Innozant ji sir thanx sir....
@@Innozant Kab post karoge aap 4000 row wala. Mere pas toh 25000 rows hai; jaldi bata dee jeye please
@@sudhasomasundaram1509 = SUM ( INDEX ( data , 0, MATCH ( lookup_value, headers, 0)))
5:18 7:33 8:01
when its 4000 where is the video?
Index series me hoga video
😀🔥
❤️❤️👍
{=SUM(HLOOKUP(P3,$J$1:$M$500,ROW($J$2:$J$500),0))}
(Jab data jayda to tab ke liye) Is approach se ho to gaya, but vo maza nhi aaya jo kisi dusre approach se hota
Ok..Ravi ji kuch aur bhi try kiya ja skta haina?
@@Innozant Ji SIr, Ise hum aur bhi tarike se kar skte hai, Jaise
via (Choose + Vlookup + SUM) =CHOOSE(VLOOKUP(P7,$G$3:$H$6,2,0),SUM($J$2:$J$500),SUM($K$2:$K$500),SUM($L$2:$L$500),SUM($M$2:$M$500))
Aur
via (SUM + INDIRECT)
=SUM(INDIRECT(P9)) se bhi ho jayega sir
Aur bhi tarike hai
Sab aapse hi sikha hai Sir,
Thank You Sir for your helpful VIdeo and Support 😊😊
=REPLACE(ABHI HAMARA TOPIC KHATAM THODI HUA HAI, 1, PICTURE ABHI BAAKI HAI MERE DOST)
Hahahahaha 🤣
Itni speed se ap explain kerte hai jaldi samajh nhi aata ap excel learn kerwa rhe hai to apko zyada samjha ker batana chahye
Dear Ydi aap Basic Excel ke pehle video se learn kar rhe hote to ye bolne ki jarurat hi nahi hoti sayad aapko..kahin se video dekhnege to speed explanation lgega kyunki concept alreday smjhaya ja chuka hoga.
Ok Sir Thanks