Use of Hlookup

Last updated at August 14, 2026 by

Just like Vlookup,Hlookup is also used to compile data from different sheets to one sheet

 

Formula of Hlookup

=hlookup(Select item,Go to Other Sheet Select Area and Press F4,Write Row No of Area,0)

 

Difference between Vlookup and Hlookup

VLOOKUP Hlookup

Full Form is

 Vertical Lookup

Full Form is

Horizontal Lookup

Item to be found is on Left Item to be found is on Right
We Write Column number of Area We Write Row number of Area
We drag down or copy paste downwards We drag down or copy paste on the right
Vlookup searches on Right Side of the item Vlookup searches Downwards of the item

 

Assigment

Assignent 6 - Form1 - Teachoo.png

Assignent 6 - Form2 - Teachoo.png

 

Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.