Comments on: How to use HLOOKUP in Excel with formula examples

The tutorial explains the specificities of the Excel Hlookup function and how to use it most efficiently. Among other things, you will learn Hlookup formulas to search with approximate and exact match, from another sheet and workbook, case-sensitive horizontal lookup, and more. Continue reading →

Table of contents

Comments page 2. Total comments: 35

  1. While using index match in a range of table having subtotals,the next line below the subtotal fetch the value in subtotal row.Please help?

  2. plz send excel file

  3. Lot of thanks.

  4. Thanks a lot for this information. I tried Hlookup with Match function as well and worked very well. Thanks

  5. Nice........

    And Thanks to uploading a sample sheet of post.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)