Excel Lookup Formulas: Lookup vs VLookup vs HLookup vs Match
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- In this tutorial, we will learn about Lookup Comparisons like lookup function, Vlookup function, Hlookup Function, and match Function in Excel with Example.
Check out our 22+ hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
Lookup vs VLookup vs HLookup vs Match | Lookup Comparisons
#vlookup #Hlookup #lookup #match #exceltricks #excelsuperstar
To watch more videos visit: www.excelsupers...
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar
Get 100% OFF on Excel Interview Essentials course *Use Coupon Code - ESSJUL20*
Hurry! Only 500 Coupons are available. Click here - bit.ly/2ZwT7vZ
Sir farmula write kr diya kro comments m
Thanks Mr. Rishabh, you're an amazing teacher with great humor and fabulous voice texture, you teach in a very simple way, I've learnt a lot from your tutorials. Thank you so much.
Aap k bolny ka style hi bohat zbrdast hai
Love from pakistan, Bohat helpful material hai apk pass or btanay ka tareeka Apka Bohat Achaa Hai❤️❤️
Rishabh Sir,
You are a great teacher, moving on a right and bright track. आपने बिल्कुल सही कहा ये concept किसी ने नहीं बताया आजतक |
Hats off to you! ; )
Your videos are amazing.thank u! I have been using Excel in the most traditional way! U were the sole reason that I have learnt formulas overnight and I was successful to use them for official purpose. Your voice is amazing! Keep up the good work!! Kudos!!
Achhi beat hai ji bano ji
Aur kai ho
May Allah Pak blesss you brother❤
Cant get better explanation anywhere else.. Superb !!
Hi Rishabh really I learned from your video thank you soooooo much dear for free of cost training. God bless you Bro.
Zabardast tareeka ha samjhanay ka. Salute from Pakistan
Thank u so much .....this video help me a lot in exams ....thank u so much
Excellent Sir
U r the best in all excell guru
Awesome video and way of expressing is outstanding.
Very Nice Sir
Index Match Bhi Isime Bata Dete Aap, To Bahut Achchha Rehta. Vaise Maine Aapka Index Match Video Dekha H.
Thanks
very superb sir ji
Superb explains each and every concept
Sir.... Your lecture is good
Thanks Sir
Superb service
Sir lookup mein backward column ya row mein bhi Dekh sakte hai
Jo hlookup aur vlookup mein kaam nhi karta
Je bhi batana Chahiye tha difference mein
very simple and good way to teach
Nice ways of explaning the topic.
Good video and always learnt something new from your videos. I hope you will continue share as much as you can. Thanks Risabh.
Wah Rishab Sir. Thank you
Excellent
Thanks 🙏 brother
This is very helpful for me .
I will take the example you explained first to clear my understanding and then will go on other examples. I will let you know, once I am done with my work.
Super Sir
Thank u, nice one to do specialisation in Look
Thankx bro very helpful
Easy understand thanks
Very well explained
Excel super star...
Thankq
Very nice Rishabh. The way you teach is super excellent. Kudos
Excellent video ... but need to teach with english for better sharing your valuable ideas....
Excellent video sir it's easy to understand 👍 please make videos on macros
Awesome
I think many people have done this type of vedio
Thanks sir 👍❤️❤️❤️
Sir Videos me picture seen
Very amazing...........😃😉😄
Thanks sir👌👈
👌
Rishab bhai Zindabad love from 🇵🇰🇵🇰🇵🇰
Easy trick hain
Very good topic
Awesome, outstanding
Sir vlookup me value duplicate ho to result kaise nikalen.exple.value ram,mohan, ram,sohan.
❤❤❤
Thank u ,Sir
Nice video sir
Mje retail audit sheet banana aur system qty aur physical qty MN diff check krna bta dn
Amazing
❤️❤️❤️❤️❤️❤️
Nice working...
Is there any method to transper data only one row to another work book if we edited only on one cell
sir main chatahu ki apki is sheet main Dealer, North, East jahape likha huya hai us jagape 30 days ke bad automatic "aap ka name" ajaye ga .......a keise karu
Nyc explained
sir ji not work my excel vlookup with match function =VLOOKUP(A3,$A$8:$E$15,MATCH(B3,$A$8:$E$8,0),0)
Nice sir
Hello, I am Looking something like this, I have added a calendar in Google sheets and every day I enter my earnings now how can I make a monthly total by formula?
Mera ek sawal hai Sir Aap se Bahot se students hai kisi ne D.pharam. mai registration karaya to kisi ne B. Pharma main karaya hai unmain kuch students ne B.pharma or D. Pharma dono main karaya hai to ense students ko kese finde karen. B.pharma, D.pharam sheet Alag Alag hain please help me
Great!
How to match rows in two different columns. Both colums have similar values. But the serial of data in both columns is mixedup. Result shud have same value in same rows in the same different columns.????
❤❤❤👍👍👍
Bro..!! Database me same Lookup value ho to Vlookup se first vala value hi ata he..
Second value lane k liye koi idea?
Nice sir.
Thanks Rishab. It is really helpful.
Do we have a training on same example with vlookup & if function?
Excel me agar koyi drop down list banyai hain to us puri list ko ek saath report kese Generate kar sakte hain please help me.
Sir.. Good evening... Mai aapka sabhi video dekhta hun... apne friend k sath share bhi krta hun... sir please mujhe Filter box k bare m bataye.... Jaise kisi sheet m koi word search krna ho search kiya hua word highlight ho jaye aur sath hi us word ka row filter ho jaye.. to kaise krenge.. please is bare m video banaye... thanks
We love you sir.
bro app ek date patten ko leke vlookup and hlookup ,sumif ka video upload kariyee please.example-date/name/department/product/total sale.app srif find kar na hai datewise konsa employee kiss tarik ko ,kitna total sale kiaa hai monthly. or use employee ka konsa wala department hai. please bro ek video upload kariyee jaroor.i am big follower of your excel superstar. please bro.as soon as upload kariyee. i am waiting your respond.
Always excellent index kab aya ga.
Osm
Nice
VERY NICE SIR, AAP ITNI HARD TOPIC BHI ITNE AASANI SE KAISE SIKHA DETE HO.
Thank you Shaikh Moiz Uddin
bhi
6 col intries hain 1000 rows hain 2nd sheet per cross mach id no sa kasa karin g ka pori row a jan
jo id no dain us id ki row ka data aa jai
audit chech . cross check
1000 rows main sa kuch rows cross check
one colum has Sunil and second colum has sunil Singh could you help me to highlight both cell with formula
Sir plz tell me f4 kyo use krte ho aap
Can u explain how to convert number into words for example Rs. 10/-. I want this to use formula and type in words
Hi...excel expert
I need a help...I stuck here
I want to count something "AA".... if I want to count "AA" in a row if "AA" in continue in a row then use count if, if some other word in same row like "BB" then again "AA" then start count after "BB" . It means if any word comes between "AA" start again to count after new word. For example......
Row=A 1 to E1 ''AA" then result show 5 if Row=F1 " BB" and again Row=G1 to J1 "AA" then result 4 ( start to count "AA" from G1) Thanks🙏
How to Vlookup and filter some different tall me
pa g nawa coat wah g
I need English!
UP
Give an ACTIVITY at the end of the video.
Sir mujhe combine formula lagana sikhna chahta hu
#Nitin Singh Click here to learn about combine Formula: th-cam.com/play/PLrR4-diP9nFQz7fs3ONOx5ANNwSMJ0qAu.html
bhai apka voice deepak kala jaise hai ,tum chhakee ho........... uhh.. i mean deepak kalal ho?
Sir
Excel me XLOOKUP KYA HAI
🔥🔥🔥🔥🔥🔥👌👌👌
Nicely explained but inserted video clip is irritating
Professional should learn vlookup and index functions
How to do multiple vlookup and conditional formating and match function.
Thoda tough tha bhai😥😥
Sorry sir mujhe clear nhi hua
Good night baby
Hi Rishab, apka video bauht helpful hote hai thanks. Mujhe apki help chahiye, mujhe meri company ka shift roster bnane me help chahiye jis mein karib 3000 employees hai, our agar kisi ko apni shift ja weekly off check krna ho toh sirf apna employe code punch kre our unka monthly shift roster show ho jaye... Agar app mujhe help krde toh bahut bahut dhanevaad apka rishab ji. Meri email : jathouls@gmail.com. App mujhe formulas bta do pls ke kon se formulas use hoge our kaise hoge.
आपका मेथोर्ड ठीक नही है समझाने का
अरे भाई खुद ही कर रहे हो ओर आगे बढ़ रहे हो कुछ समझा भी दो
Thanks sir
Excellent
Tq so much sir