Learn HLOOKUP in Excel - The basic comparison between HLOOKUP and VLOOKUP
HTML-код
- Опубликовано: 6 фев 2025
- The HLOOKUP function searches for a value in the first row of a table, and returns another value from the same column in that table. It is very similar to VLOOKUP, which is used for vertical lists.
To download the same file for practice:
prabastech.com...
First, Learn the VLOOKUP Function and it various usages to be mastered in HLOOKUP
• Learn VLOOKUP Excel Fu...
Excel Training in Tamil:
• Learn VLOOKUP Excel Fu...
~-~~-~~~-~~-~
Please watch: "Play with Duplicate Data in Excel - Part 2 - Highlight, Remove, Trigger"
• Fix Duplicate Data in ...
~-~~-~~~-~~-~
You are explanation is keen bro
Most of the tutors will confuse vlookup & hlookup..But this video gave me a better clarity between vlookup & hlookup..
Thank u so much Sir.
Thank you I got little bit understand between v and h lookup function
Thank u Anna supera sollitharinga thank u
Thanks for your comment.
Request you to watch rest of the videos too from the provided playlist.
Top Excel Videos of 2019 - Tamil: ruclips.net/p/PLXqX9fbIzJMacejGRWRJnHBkTb4seu0j4
Good explanation.. good job
Glad you liked it
Tq you sir . You explain nicely
Thanks Maheswari
Super nice
Excellent & very helpful, thank you very much for your social interest
Thanks for your comment Mukesh.
Welcome to PrabasMsoffice.
Good teaching. Thanku
நன்றி
Super bro..
Nice teach bro...
super sir
Super
There are some PLAYLISTS available in our channel. Do watch them.
2019 version la x loolup ila bro. Yentha version la available? And ilatha version la yepdi add panurathu define plz
Microsoft Says:
XLOOKUP is not available in Excel 2016 and Excel 2019, however, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it created by someone else using a newer version of Excel.
good
Please consider to subscribe to our RUclips channel. Thanks.
Thank you sir
Keep following Sathish.
Excel Match Formula in Tamil: ruclips.net/p/PLXqX9fbIzJMbbaCosdLTN-OF0ser2zGXu
NICE SUPPORT BRO..IF FOLLOW UR VIDEO REGULARLY WE WILL BECOME MASTER OF EXCEL.. AS UR GUIDE I CORRECTED MY MISTAKE...
+Ameer Hamja
Super Ameer, keep watching and supporting.
Sir please upload a video of xlookup
Bro one request Averageif & Averageifs pathi kojam detaila videos poduga bro
Sure Prasanna. Happy learning.
Super sir but I have one doubt it works when the names are in different order
Yes , it works.
Hai sir,
I have doubt in vlookup,
I enter one name repeatedly in vertical.in vlookup the first column details only reflect.how can I get full list details of that same name .
Using vlookup, it is not possible. Buy we can do some alternative. If you clearly define your complete requirement, i able to help you. If possible, share a dummy excel sheet which explains your requirement.
@@Prabasmsoffice
Ok sir tomorrow I share you the sample copy for your reference
Hie Sir! Can i get working file's for Hlookup for practice purpose? Let me understand better by solving different kind of problems.
+RAVI KIRAN
Sure, the same will be updated in the channel's description soon. Thanks for the comment.
www.prabastech.in/free-downloads/
Sir mobile number enter panni name ah find panna N/A error varudhu
Mobile number neenga type pannura mathiri database la irundhaa error varadhu.
Number illanaa thaan error varum.
Bro pls teach like And, or, If formulas and conditional formatting..
+Ameer Hamja
Sure, in the future videos you could see them.
Thanks for your interest.
Prabas msoffice Welcome bro
I have one doubt bro first bala name 4 placesla irundhuchu nenga 3 type panninga then hlookupla pannumodhu quality 4 placela iruku vlookup valuela 4 type pannirukinga
Understand this very clearly by watching the video again. In the example 1, the salary is in 3rd column (vlookup). In the example 2, the salary is in 3rd row (hlookup).
In the practice, the quality is in 4th row (hlookup), so the the number in the "column index" should change based on the expected output.
Request you to watch the basics from the following to be mastered in VLOOKUP & HLOOKUP.
ruclips.net/video/GMYeU-Hiuzo/видео.html
I hope you will understand it, expecting your replay on the same.
How to lock the cell using f4 ? I'm using Excel 2013
+Renish Raj
I have explained locking concept using F4 in the following Video, this will help you.
ruclips.net/video/GMYeU-Hiuzo/видео.html
Please explain =sumproduct(--( double hyphen using in sumproduct
Sure
Old formula, but still people are using it.
SumProduct Excel Formula in Tamil - தமிழ்: ruclips.net/p/PLXqX9fbIzJMbnUVB2_b9-yVJfIFns2j3K
SumProduct Excel Formula in Tamil - தமிழ்: ruclips.net/p/PLXqX9fbIzJMbnUVB2_b9-yVJfIFns2j3K
How to use ladder In excel
Which one do you need:
1 Leader line on chat.
2 Ladder chart
Please confirm you to support you better. Thanks.
G Excel New vedio will be published
hi brother age formula year and date venum
+asper ali
To find number of years
=DatedIF(Starting date, end date, "Y")
To find number of days
=DatedIF(Starting date, end date, "D")
good