Excel Formulas to Get the First Text Value with HLOOKUP Function!!
Tags: excelformula, excelformulas
Published: 2021-01-12 03:52:07

---
title: Excel Formulas to Get the First Text Value with HLOOKUP Function!!
published: true
date: 2021-01-03 16:07:55 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-get-first-text-value-with-hlookup/
---

Before entering into this article, you need to know what is HLOOKUP Function? It is nothing but the horizontal Lookup value. In this previous post, we have seen the formula to get the first text value in Excel based on the **[VLOOKUP Function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/).** Similarly, here we will show the simple formula used to **get the first text value with the HLOOKUP function**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get first text with HLOOKUP](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Get-first-text-with-HLOOKUP.png)](https://geekexcel.com/excel-formulas-get-first-text-value-with-hlookup/get-first-text-with-hlookup/#main)<figcaption id="caption-attachment-20551">Get first text with HLOOKUP</figcaption>

## Jump To:

- [**General Formula**](#1)
- [**Syntax Explanations**](#2)
- [**Example**](#3)
- [**Closure**](#4)

## General Formula:

- To find the first text value, you can use the HLOOKUP function.

**=[HLOOKUP](https://geekexcel.com/use-hlookup-function-in-microsoft-excel-365-in-easy-ways/)(“\*”,range,1,[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/))**

## Syntax Explanations:

- **HLOOKUP** – In Excel, this function will help to lookup and retrieve data from a specific row in the table. Read more on the **[HLOOKUP function](https://geekexcel.com/use-hlookup-function-in-microsoft-excel-365-in-easy-ways/)**.
- **FALSE** – The Excel **[FALSE function](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/) **returns the logical value FALSE.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Asterisk (\*)** – An asterisk (\*) means **“one or more characters”**.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input data given in the worksheet.

## Example:

- Let’s consider the below image to get the first text value in a row.
- First, we will give the input values in **Column B** to **Column E**.
- Then, enter the given formula in the formula bar section,
- Finally, you can get the result in **Cell G4**.

![Example55](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-88.png)<figcaption id="caption-attachment-20553">Example55</figcaption>

## Closure:

So yeah guys, this is how you can **get the first text value with the HLOOKUP Function in Excel**. If you have any questions, feel free to comment. Thank you so much for Reading!! To learn more, check out our website **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- [**Excel Formulas to Get the First Matching Value from the Text String!!**](https://geekexcel.com/excel-formulas-get-first-matching-value/)
- **[Formulas to Count Unique Text Values with Criteria in Excel!!](https://geekexcel.com/formulas-to-count-unique-text-values-with-criteria-in-excel/)**