Match function with VLookup formula in Excel | Part 1 | Hindi
Вставка
- Опубліковано 2 сер 2016
- This technique is useful when you have to look up a value in a table with both horizontal and vertical coordinates.
We basically, select the table using VLOOKUP and select the relevant column using the MATCH function. This technique can be used which analyzing sales data, logistics, employees data.
The Match is a Junior formula, and VLookup is a Senior formula.
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
Match function with VLookup formula in Excel | Part 1 | Hindi
#2Dlookup #Matchandvlookup #excelformulas
Get 100% OFF on Excel Interview Essentials course Use Coupon Code - ESSJUL20
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course Pen drive visit: www.excelsuperstar.org/excel-t...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![Excel VLookup Formula in 8 Minutes [VLookup in Excel]](/img/n.gif)
Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20*
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
I'm your fan i really like your video i don't need any couching becouse of you thanks
So nice of you
Sir Very Useful for Myself.
Thanks A Lot Sir
best video lesson ever.... period!!!
good vedio ..... good teaching skills and simple n superb .... cong !!! ... please keep it up
Thank you Rishabh Sir.
Very Useful Information, sir!
Thankfulness!
The way u teach is awesome. Brilliant Sir..
Thanks, after trying for almost 6 hours searched on youtube and got this video. applied in just 2 minutes
Superb explanation...thanks sir for sharing....love it
Excellent explain 🙏
Thank you,sir.
speechless... Rishav.... UA-cam should give you price... fabulous... please😫🙏🙏💓 keep it up
GREAT SIR,
THANK U.
Easy Explained
Thanks for that match function info 👍👍👍
It is too useful video for excel user
Thank you so much sir
Thank you dear.
Rishabh Sir, i got a lot of videos in youtube but your teaching skills are simply awesome
Wah super teaching
Ultimate explanation sir
The way you have explained is remarkable :)
Great brother.
very helpful video ,sir
Useful video and very easy to learn. Thanks a lot sir
Thank you sir
Excellent example bro keep it up
খুব সুন্দর ভিডিও ...
Superb teaching skill and seen like this.
Very informative
Great!!
thanks sir
Outstanding
Nice explanation
Awsome
Amazing Rishabh...
Excellent
Your teaching is good...
tremendous video
Very Good Sir .....👌
Very nice sir 🤔
Good example
Super Sir
very nice tutorial sir
Thank youuu 😭
VERY NICE
useful
very good /also style
Its little bit difficult but your teaching style is awesome........i really like..........
Gud one!! 👍
Easy Explained
👌
Advanced Excel Webinar v2.0
Hurry up!
Book your seats now(limited seats)
www.excelsuperstar.org/
good
Make good understood
very nice sir..its very easy to understand.. good explaination ..
thanks sir..
guide and help me with much more videos.
sir plz make a video of vlookup on two or more sheet working together.
yes sir, please work on it.
Nice ( from Bangladesh)
sir one question
agar mendatory field 2 ki jagah 3 ya 4,5 ho to kaise emplement karenge formula.
Very Nice but if we have duplicate values in our worksheet vlookup return same value for all duplicates what is the solution for return to uniqe value suppose we have a two duplicate name but their values is different we want to show both with different values
We can use index match also
Offset and match combine video in same and different sheet...
Share it
Sir please help me wid vlookup,I found difficulty in adjusting value which contains same number (suppose in ur eg.there are 2 farm fresh pizzas but with different prices how to adjust different prices) bcoz when I tried using vlookup I did not came wid the same
Match formula ka yse horizontal kiya jata h ya fir vertically ya dono
very nice thanks for this video i want to subtotal in single item from lot of different items please guide me. Thanks in advance
Subtotal() Function
Follow link: ua-cam.com/video/uQ-STCJiUWY/v-deo.html
Plz provide macros formula in advance stage
Kindly make a
Salary sheet with tax calculation
have question, if i want to use lets say Sheet 1 has A(Emp ID), B(project, C(%) column & sheet 2 has x, y, z column(same as sheet 1).
if i do vlookup with column A(Emp ID) i'll get value which is in sheet 2 for A.
Question : if for same Emp ID, if there are two projects with different 'C' value of 75 & 25%, how vlookup can give exact answer ?
Please help
SIR MUZE EK QUESTION HAI JAB MAIN CELL P1 TYPE KARTA HOON TO USKA 8 VALUE HONA CHAIHE
Hello, How can i write this formula in vba? İs there any way to do it?
How to choose 2 lookup values?
SIR IF DUPLICATE KI ENTRY KI LOOKUP DEKHANA HO TO KAISE DEKH SAKTE H -EX- FRESH-SMALL(55)
FRESH-LARGE(5)
Hello sir, I used this formula but mene jb mene ise drag kiya toh mujhe kafi problem ayi hai like agr me vertically drag kr rha hu toh mujhe kuch cells lock krne pr rhe hai lekin usi time agr me horizontally drag kr rha hu toh mujhe unhe unlock krke dusre cells freeze krne pd rhe hai please ap iska solution btafo
sir muja app ki vidio achi lagi ...ek vidio ASE Bano Jasa ki excel me. 2 sheet hote hai first or second . First sheet me SE 154 item jo 01/2/2017 ka Data hai or second sheet me hai 160 item hai who data 03/ 2/2017 ka hai .ab mere seconds sheet me kitne entry hua hai who kase pata karega.
trick se jyada apka vocal acca lagtahe
Sir some times in some excel sheet vlookup is not working. What could be the possible error. Note I was using the formula correctly
GOOD EVENING SIR.
I'VE ONE QUERY.
WHAT IF FIRST CELL IS FILLED?
COZ I'M GETTING ERROR
How to make shpes by cell value without vba
have done the same thing but not able to find the price of 'small' of any 'pizza type'. Please help
Thanks for the video.
Could you please help me below the question..
Ex..
Name volume
A. 10
B. 15
A. 30
C. 20
A. 50
How to sum A's values via vlook up formula.
AJ GAMERS friend why you want to use vlookup for this simple question
Esa koi function h Kya jiske threw m
Ek student ki attendence lgau or sbki lg Jaye ???
I am getting error while practicing this formula
Hello sir, can you please tell about how to use vlookup when we have multiple value......
Ashish Sharma i also want to know
+Naveen Swami He doesn't know it,thats why not replying.
Naveen Swami what you want to know from me?
Despite hectic efforts I could not get success to do the similar excercise.
Hi nice video.
I have a query if u can solve it will be a lot of help.
I have a data sheet where bedroom size is 1 & bathroom size is 1 anf many sizes. How can I assign them A1,B1, C1
1BD - 1BA = A1
1BD - 1.5 BA = B1
1BD - 2BA = C1
2BD - 1BA= D1
2BD - 1.5 BA = E1
Another condition is...
1BD - 1BA = A1
1BD - 1.5 BA = B1
2BD - 1BA= C1
2BD - 1.5 BA = D1
Another condition is...
1BD - 1BA = A1
2BD - 1BA= B1
2BD - 1.5 BA = C1
$q lagate h
एक फ़ाइल में 5 शीट है अब एक शीट में ,4 शीट के , 10 colume के एक साथ velookup से डेटा कैसे ले
Dude are you a dubbing artist? If not you should give it a try
Where is "" Match function with VLookup formula in Excel | Part 2 | Hindi" ?
Is this english? No it isnt.
Why is the title then in english.
thanks sir