Learn HLOOKUP in Excel - The basic comparison between HLOOKUP and VLOOKUP

[@WisdomRoot]

You are explanation is keen bro

[@tharunkumar1958]

Most of the tutors will confuse vlookup & hlookup..But this video gave me a better clarity between vlookup & hlookup.. Thank u so much Sir.

[@gobisekaran5102]

Thank you I got little bit understand between v and h lookup function

[@manivasaganed4713]

Good explanation.. good job

[@Prabasmsoffice]

Glad you liked it

[@10dicfvisnuvaradhan71]

Thank u Anna supera sollitharinga thank u

[@Prabasmsoffice]

Thanks for your comment. Request you to watch rest of the videos too from the provided playlist. Top Excel Videos of 2019 - Tamil: kzbin.info/aero/PLXqX9fbIzJMacejGRWRJnHBkTb4seu0j4

[@mukeshm5308]

Excellent & very helpful, thank you very much for your social interest

[@Prabasmsoffice]

Thanks for your comment Mukesh. Welcome to PrabasMsoffice.

[@kumar18568]

Good teaching. Thanku

[@maheshwarimaheshwari8875]

Tq you sir . You explain nicely

[@Prabasmsoffice]

Thanks Maheswari

[@ameerhamja2893]

Nice teach bro...

[@6070avm]

நன்றி

[@sivanandanmohankumar5284]

Super nice

[@solaimalairamasamy9348]

Super bro..

[@balaandrews]

2019 version la x loolup ila bro. Yentha version la available? And ilatha version la yepdi add panurathu define plz

[@Prabasmsoffice]

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.

[@ameerhamja2893]

NICE SUPPORT BRO..IF FOLLOW UR VIDEO REGULARLY WE WILL BECOME MASTER OF EXCEL.. AS UR GUIDE I CORRECTED MY MISTAKE...

[@Prabasmsoffice]

+Ameer Hamja Super Ameer, keep watching and supporting.

[@aliyarhusain8276]

super sir

[@VenkateshVenkat-lc5my]

Super

[@Prabasmsoffice]

There are some PLAYLISTS available in our channel. Do watch them.

[@Karthick_pavithra]

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 .

[@Prabasmsoffice]

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.

[@Karthick_pavithra]

@@Prabasmsoffice Ok sir tomorrow I share you the sample copy for your reference

[@prasannaprit6608]

Bro one request Averageif & Averageifs pathi kojam detaila videos poduga bro

[@Prabasmsoffice]

Sure Prasanna. Happy learning.

[@kodairoadkannan]

good

[@Prabasmsoffice]

Please consider to subscribe to our KZbin channel. Thanks.

[@ravikiran1560]

Hie Sir! Can i get working file's for Hlookup for practice purpose? Let me understand better by solving different kind of problems.

[@Prabasmsoffice]

+RAVI KIRAN Sure, the same will be updated in the channel's description soon. Thanks for the comment.

[@Prabasmsoffice]

www.prabastech.in/free-downloads/

[@ameerhamja2893]

Bro pls teach like And, or, If formulas and conditional formatting..

[@Prabasmsoffice]

+Ameer Hamja Sure, in the future videos you could see them. Thanks for your interest.

[@ameerhamja2893]

Prabas msoffice Welcome bro

[@Kiranck1]

Sir please upload a video of xlookup

[@yuvarajnethaji3558]

Sir mobile number enter panni name ah find panna N/A error varudhu

[@Prabasmsoffice]

Mobile number neenga type pannura mathiri database la irundhaa error varadhu. Number illanaa thaan error varum.

[@BalaMurugan-br5mo]

Super sir but I have one doubt it works when the names are in different order

[@Prabasmsoffice]

Yes , it works.

[@Dark_demon07]

Thank you sir

[@Prabasmsoffice]

Keep following Sathish.

[@Prabasmsoffice]

Excel Match Formula in Tamil: kzbin.info/aero/PLXqX9fbIzJMbbaCosdLTN-OF0ser2zGXu

[@renishraj4645]

How to lock the cell using f4 ? I'm using Excel 2013

[@Prabasmsoffice]

+Renish Raj I have explained locking concept using F4 in the following Video, this will help you. kzbin.info/www/bejne/fX68lohjfc6osNE

[@vanakam3036]

Please explain =sumproduct(--( double hyphen using in sumproduct

[@Prabasmsoffice]

Sure

[@Prabasmsoffice]

Old formula, but still people are using it.

[@prabas2006]

SumProduct Excel Formula in Tamil - தமிழ்: kzbin.info/aero/PLXqX9fbIzJMbnUVB2_b9-yVJfIFns2j3K

[@Prabasmsoffice]

SumProduct Excel Formula in Tamil - தமிழ்: kzbin.info/aero/PLXqX9fbIzJMbnUVB2_b9-yVJfIFns2j3K

[@nandhiniprakash8254]

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

[@Prabasmsoffice]

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. kzbin.info/www/bejne/fX68lohjfc6osNE I hope you will understand it, expecting your replay on the same.

[@RajaS-lq9hd]

G Excel New vedio will be published

[@kumaranprabsprab8473]

How to use ladder In excel

[@Prabasmsoffice]

Which one do you need: 1 Leader line on chat. 2 Ladder chart Please confirm you to support you better. Thanks.

[@jokermam5577]

hi brother age formula year and date venum

[@Prabasmsoffice]

+asper ali To find number of years =DatedIF(Starting date, end date, "Y") To find number of days =DatedIF(Starting date, end date, "D")

[@Anshusharma-yf3im]

good