How To Use HLOOKUP Formula in Microsoft Excel | HLOOKUP in Excel
Ғылым және технология
In this video we will learn how to use HLookup Formula very easily. HLookup also known as Horizontal Lookup. You can use HLookup Formula to find data in Row in Excel.
My channel publishes videos on Computer Skills and Tricks. I have changed my channel's name from "uttam's Tech diary" to "StudySpan" due to some technical issues.
Please Subscribe to my channel and keep your support!!
#hlookup
#hlookupinexcel
#hlookupinexcelinhindi
#studyspan
Music: Outside
Musician: @iksonmusic
Thank you
Пікірлер: 97
Samajh aagaya sir thanku🙏
Most useful video 👍
Thank you Sir Your Explaination is very neat and clear.
Very useful 👍
Good knowledge sir
Superb! Thanks to You for giving us this best Information.
Super sir thank you ❤️
Nice video Baut Accha Tareeka hai Understand karane ka
Buhot Interesting video
Awesome 👍
Superb sir👍
Thanks sir for this helpful video
Nice great 👍
thank you so much dear, you solve my biggest problem.
Nice video it will help me very much
Very nice sir❤
Very very easy ways thanku sir
Thnx
Like....👍👍👍 Love you 💛
TOO GOOD SIR
thank for explaining hlookup!!
@_Shubham-bhatia
10 ай бұрын
kzread.info/dash/bejne/dKZ7ma1sqcLPnqw.htmlsi=TyP585ioCAYBzLnr
Thank you sir hmko smjh aaya means sbko smjh aaya 😄😄
@YASHVEERSAIN2003
Жыл бұрын
Ram Ram Anjali Ji I am Yashveer Singh dahiya From Sonipat Haryana 🇮🇳🕉️
INTERESTING
Bahut acha bataya
Sir is Tara ka or vi video upload kor Nice sir Power full video upload , God bless you ❤️🙏 Thank you so much😊
Thanks. Very useful video. I learn hlook and vlook from your videos
@_Shubham-bhatia
10 ай бұрын
kzread.info/dash/bejne/dKZ7ma1sqcLPnqw.htmlsi=TyP585ioCAYBzLnr
good topic sir
Thnku sir 🙏
Excellent 💯👍👍💯
@_Shubham-bhatia
10 ай бұрын
kzread.info/dash/bejne/dKZ7ma1sqcLPnqw.htmlsi=TyP585ioCAYBzLnr
❤❤❤❤🎉 thanks 👍
समझ आ गया सर 🎉
Awesome 👌 #SunnyHotWheelsS 😎
@StudySpan
4 жыл бұрын
Thank you... Stay tuned
Thank you so much sir please creat more videos of advance excel please sir
Thank you sir ❤
Thank you sir
👍Very fruitful.
Very helpful
@StudySpan
3 жыл бұрын
Thank you so much
Awesome movie
Wow ....sir jantam na apni ato bhalo Hindi bolen ...good luck 🙂
@StudySpan
4 жыл бұрын
Thank you... Stay tuned for latest videos
@YASHVEERSAIN2003
Жыл бұрын
Ram Ram somyukta Ji I am Yashveer Singh dahiya from sonipat Haryana 🇮🇳🕉️
Thank you
Thank u
Thank you sir, explain H look up formiula
Very nice video sir👌
@StudySpan
4 жыл бұрын
Thank you... Stay tuned
in hlookup function drag horizontal is not working after double click on formula then works, what is the logic behind it
Bpk স্যার
@StudySpan
4 жыл бұрын
Thank you... Stay tuned
👌👌👌
Tnx
Sir you teached us HLookup in the most simplest way. Thankyou sir.
👍👍👍
Thanks ❤ informative video
tq
❤️❤️❤️❤️❤️❤️❤️
❤❤❤
Nice
@StudySpan
4 жыл бұрын
Thank you... Stay tuned for latest videos
😃
Thanks Sir help karna kaliya
@StudySpan
4 жыл бұрын
You are mostly welcome... Stay tuned for more videos
ek hi bar me hlookup use nahi kar sakte kya sir?
H look up keliye V look up ki tarah F4 de ke fridge nehi kirna porega kya sir?
Table array ko lock q nhi kiya f4 press karke?
@_Shubham-bhatia
10 ай бұрын
kzread.info/dash/bejne/dKZ7ma1sqcLPnqw.htmlsi=TyP585ioCAYBzLnr
In vloop up you have used F4 to fix the data,...why you have not used F4 in hook up
sir plese provide us readymade practice table
Assalam O Alaikum sir. Is question hoa apse.. ese to isme vlookup Ka bhi formula use kr sakte hen? Q k dono formulas Ka kaam ek jesa hi to hai? And plz??
@StudySpan
2 ай бұрын
Aap apne retirement ke anusar kisi bhi lookup ko apply kar sakte ho
What if emp id and emp name is given i applied through emp name but emp id chage hi nahi hoti same with emp id emp name change nahi hota
@StudySpan
Ай бұрын
Requesting you kindly video ko acche se dekhiae then apply kijiye
how to apply hlookup formula for thousands of employes in short trick
If we want to delete this filter option then what we have to do..???
@foodiefanatics
10 ай бұрын
Go to data validation, remove everything from source, then choose any value from the Allow Drop-down. Then OK. Done it will be removed
Vlookup me hum F4 se table freeze kar rahe the.. isme kyu nahi kar rahe hain?
Agar H Filter karna ho to kaise karenge ??? Please answer
Data bada hoga to hm 2016 , 2017 ko spot kese karege ki wo 4th me he ya 5th me????
@nitish2799
Жыл бұрын
Actually data bade zada nahi honge.. Islye kyu ki ye table jispe Hlookup lagana hai, wo right ki taraf zada phailega than bottom ki taraf.. Matlb ye table jispe Hlookup lagana hai, wo Broad zada hoga.. Thousands of Employees could be there, but number of years in which sales are being by the thousands of Employees will remain very few.. Coz for practical purposes, in a Company or something, not more than ten or twenty years sales figures will be required.. But sales figures of thousands of Employees may be required.. I hope you understand, what I am trying to explain to you..
@quratulein7002
Жыл бұрын
Then u can write it manually 2016
@whatsappstatusvinod_sone7600
11 ай бұрын
Index and match formula sath me use krna hoga
@mansii.1
4 ай бұрын
Ok I understood..thank you
@Shabbeer886
Ай бұрын
Index matching
Sirf false ka use q karte h q nhi true ka use karte h?
hum ismai f4 nhi press kare ghe vlookup mai press kara tha
Sir h look up nahi nikal find ho raha hai 5-6 try kr chuki hu
Vlookup ma cell Jo freez Kiya tha is ma ap Ku NH kr rhy??
@Akay454
2 ай бұрын
Yes that is my question too
@BROKEN_ARROW_FF
3 күн бұрын
Colum lock kro hojay
thank you sir