<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

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

VLOOKUPHlookup

Full Form is

 Vertical Lookup

Full Form is

Horizontal Lookup

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

 

Assigment

There are data in different sheets about Sales,Item Sold,Sales man name and Tax Rate

Compile data from Different Sheets using Hlookup

 

For Example

Take Sales in Quantity from Price per Quantity from SALES DETAILS Sheet

Item Sold from ITEM SOLD and SALESMAN SHEET

Use of Hlookup - Hlookup

 

 Download File and Try

 

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
  • Shivali Gambhir's image

     Sir, i am practising all lessons daily its really helping me alot can i get more assignments for practise ?

    thanks alot for sharing lessons and helping students like us

    really thankful to you :)

    View answer
  • ARIHANT YAMAHA's image

    I am using lock only selected columns in excel sheet , no other columns or rows .

    please guide me about my question..?

    View answer
  • Isha Gupta's image

    Not able to calculateitems sold, as the salesman name is written below item name.

    help needed !!

    View answer
Jail