# Lookup Functions - Hlookup, Index Match

**HLookup Formula**

HLOOKUP is an Excel function to lookup and retrieve data from a specific row in table. The "H" in HLOOKUP stands for "horizontal", where lookup values appear in the first row of the table, moving horizontally to the right. HLOOKUP supports approximate and exact matching.

>  **=HLOOKUP (value, table, row\_index, \[range\_lookup])**

**Index Formula**

The INDEX function in Excel is fantastically flexible and powerful, and you'll find it in a huge number of Excel formulas, especially advanced formulas. But what does INDEX actually do? In a nutshell, INDEX retrieves values at a given location in a list or table.

> **=INDEX(array, row\_num, column\_num)**

**Match Formula**

The MATCH function is designed for one purpose: find the numeric position of an item in a list. 

> **=MATCH(lookup\_value, lookup\_array, match\_type)**

**Index Match together**

INDEX and MATCH functions gives you better control over how the row index number and column index number changes.  This is often referred to as a dynamic formula.  You will learn how this dynamic duo can help prevent errors and improve your INDEX formulas.

> **=INDEX(array, MATCH(lookup\_value, lookup\_array, match\_type), MATCH(lookup\_value, lookup\_array, match\_type))**

{% file src="/files/-LRwJl3dfVjlUc3VFy0d" %}
Hlookup, Index Match Formula Example
{% endfile %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://books-gyansetu.gitbook.io/advanced-excel/lookup-functions-hlookup-index-match.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.