Match function with VLookup formula in Excel | Part 1 | Hindi

Подписаться 385 тыс.

Просмотров 135 тыс.

50% 1

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.excelsupers...
To Buy an Excel Course Pen drive visit: www.excelsupers...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 100

@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

@prakashpal1623 2 года назад

I'm your fan i really like your video i don't need any couching becouse of you thanks

@ExcelSuperstar 2 года назад

So nice of you

@mohd.billalhossain5072 3 года назад

Sir Very Useful for Myself. Thanks A Lot Sir

@balance1772 4 года назад

speechless... Rishav.... RU-vid should give you price... fabulous... please😫🙏🙏💓 keep it up

@mirfarhad1989 6 лет назад

Rishabh Sir, i got a lot of videos in youtube but your teaching skills are simply awesome

@MrPZAHOOR 5 лет назад

Thank you Rishabh Sir.

@siddappadhangar9691 2 года назад

Excellent explain 🙏

@ExcelSuperstar 7 лет назад

Advanced Excel Webinar v2.0 Hurry up! Book your seats now(limited seats) www.excelsuperstar.org/

@avisingh9830 4 года назад

Thanks, after trying for almost 6 hours searched on youtube and got this video. applied in just 2 minutes

@rupvarsh 4 года назад

Superb explanation...thanks sir for sharing....love it

@babulalgupta3472 4 года назад

Easy Explained

@SAXENA2904 7 лет назад

good vedio ..... good teaching skills and simple n superb .... cong !!! ... please keep it up

@babukuriakose5279 4 года назад

Wah super teaching

@mahabiraggarwal8426 4 года назад

Useful video and very easy to learn. Thanks a lot sir

@vikivoicecoach 3 года назад

The way you have explained is remarkable :)

@ibm98852 5 лет назад

Your teaching is good...

@leondsouza4253 7 лет назад

best video lesson ever.... period!!!

@naveen20054 7 лет назад

The way u teach is awesome. Brilliant Sir..

@pandharinathjoshi6565 5 лет назад

Ultimate explanation sir

@mirfarhad1989 6 лет назад

Its little bit difficult but your teaching style is awesome........i really like..........

@kaitiprema 5 лет назад

Superb teaching skill and seen like this.

@abhishekupadhyay1930 7 лет назад

It is too useful video for excel user Thank you so much sir

@prashantcreative5901 3 года назад

Very Good Sir .....👌

@surajkumar-zq1ug 5 лет назад

very helpful video ,sir

@bhesaniyarajesh1750 2 года назад

Thank you sir

@ullahharis 5 лет назад

Thanks for that match function info 👍👍👍

@9894208767 3 года назад

Offset and match combine video in same and different sheet... Share it

@mahaboobhossain5076 5 лет назад

Excellent

@vivekpote1392 7 лет назад

Very Useful Information, sir! Thankfulness!

@avishekbanerjee7486 5 лет назад

GREAT SIR, THANK U.

@AmazingAnwar 6 лет назад

Excellent example bro keep it up

@deeplathania786 7 лет назад

very nice tutorial sir

@DigiMax_Com 6 лет назад

Thank you dear.

@jhzkhattak 7 лет назад

Very informative

@kumarsaroj5495 7 лет назад

Nice explanation

@jamilhfl 2 года назад

Kindly make a Salary sheet with tax calculation

@MyTech12 6 лет назад

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

@Srd_Prasanna 3 года назад

Sir some times in some excel sheet vlookup is not working. What could be the possible error. Note I was using the formula correctly

@ashokshinde192 5 лет назад

Thank you,sir.

@shivahir6542 5 лет назад

We can use index match also

@srikanthc2348 7 лет назад

Good example

@abrarsiddiqui3615 7 лет назад

sir one question agar mendatory field 2 ki jagah 3 ya 4,5 ho to kaise emplement karenge formula.

@chintewargajanan1842 7 лет назад

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.

@vivekpote1392 7 лет назад

yes sir, please work on it.

@sayedsohel6674 6 лет назад

খুব সুন্দর ভিডিও ...

@swapnilrajput8086 2 года назад

have done the same thing but not able to find the price of 'small' of any 'pizza type'. Please help

@arijeetkumarsharma226 5 лет назад

Outstanding

@MRHACKER801 7 лет назад

Awsome

@theexplainer3617 6 лет назад

tremendous video

@nazirahmed3292 7 лет назад

very good /also style

@uditnarayanshukla8606 2 года назад

Make good understood

@heeraramkumawat6847 6 лет назад

VERY NICE

@jitabhi123 7 лет назад

Plz provide macros formula in advance stage

@sachinrv1 7 лет назад

Amazing Rishabh...

@madhavirajput5325 7 лет назад

thanks sir

@pckgpl2968 7 лет назад

SIR IF DUPLICATE KI ENTRY KI LOOKUP DEKHANA HO TO KAISE DEKH SAKTE H -EX- FRESH-SMALL(55) FRESH-LARGE(5)

@pocketcomputer3084 6 лет назад

Very nice sir 🤔

@ultimatemind8115 5 лет назад

GOOD EVENING SIR. I'VE ONE QUERY. WHAT IF FIRST CELL IS FILLED? COZ I'M GETTING ERROR

@samarabbas9607 4 года назад

How to make shpes by cell value without vba

@vaishalikorbe9225 6 лет назад

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

@vinay103 5 лет назад

Great!!

@ritikjain7978 3 года назад

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

@begnasonline8299 7 лет назад

very nice thanks for this video i want to subtotal in single item from lot of different items please guide me. Thanks in advance

@ExcelSuperstar 7 лет назад

Subtotal() Function Follow link: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uQ-STCJiUWY.html

@yogishbollary7179 6 лет назад

Super Sir

@AnkitVerma-cn3px 4 года назад

good

@somenmondal2964 5 лет назад

Nice ( from Bangladesh)

@prafulsambe 6 лет назад

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

@aliilkerseckin2176 5 лет назад

Hello, How can i write this formula in vba? İs there any way to do it?

@jaiswarp9788 7 лет назад

useful

@vinodvishwakarma5387 5 лет назад

👌

@subhashbhore9619 6 лет назад

SIR MUZE EK QUESTION HAI JAB MAIN CELL P1 TYPE KARTA HOON TO USKA 8 VALUE HONA CHAIHE

@trsr2208 5 лет назад

Thank youuu 😭

@sonalikumari601 6 лет назад

Esa koi function h Kya jiske threw m Ek student ki attendence lgau or sbki lg Jaye ???

@CrazyAviationTube 2 года назад

trick se jyada apka vocal acca lagtahe

@navalsharma5669 6 лет назад

I am getting error while practicing this formula

@gnnitinkumar833 5 лет назад

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

@ajgamers9547 5 лет назад

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.

@eModernGuruji 5 лет назад

AJ GAMERS friend why you want to use vlookup for this simple question

@भारतकीदुनिया 7 лет назад

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.