Excel Formulas To Map Text to Numbers ~ Easy Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-03-06 11:57:14

---
title: Excel Formulas To Map Text to Numbers ~ Easy Tutorial!!
published: true
date: 2021-03-06 11:54:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-map-text-to-numbers/
---

In the previous post, we have learned **[how to map inputs to arbitrary values in Excel](https://geekexcel.com/excel-formulas-to-map-inputs-to-arbitrary-values-easy-tutorial/)**. Similarly, here we will show the simple formulas used to **map or translate the text inputs to given arbitrary numbers in Excel**. 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)

[![Map text to numbers](https://geekexcel.com/wp-content/uploads/2021/03/Map-text-to-numbers.png)](https://geekexcel.com/excel-formulas-to-map-text-to-numbers/map-text-to-numbers/#main)<figcaption id="caption-attachment-22311">Map text to numbers</figcaption>

## Generic Formula:

- You can use the below formula to get the numeric value based on given text input.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(text,lookup\_table,column,0)**

## Syntax Explanations:

- **VLOOKUP** – This function is used to look up data in a range or table by row. Read more on the [**VLOOKUP Function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/).
- **Text** – It represents the criteria value for find the input values.
- **Lookup\_Table** – It represents the input table value.
- **Column** – It represents the column number.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Let’s consider the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-8.png)<figcaption id="caption-attachment-22313">Input Ranges</figcaption>

- Then, apply the above-given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section and press the **“Enter”** key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/Enter-the-formula-9.png)<figcaption id="caption-attachment-22312">Enter the formula</figcaption>

- Finally, it will display the result as per the given image.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-10.png)<figcaption id="caption-attachment-22314">Result</figcaption>

## Verdict:

Here, we provide a simple formula used to **map the text inputs to numbers in Excel**. Hope you like this article. Let me know if you have any **doubts** regarding this article or any other **Excel/VBA** topic. Thank you so much for visiting our site!! To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Check the Cell Value Based on IF Else Condition!!](https://geekexcel.com/excel-formulas-to-check-the-cell-value-based-on-if-else-condition/)**
- **[Excel Formulas to Check If Cell Value is Greater than Given Criteria!!](https://geekexcel.com/excel-formulas-if-cell-value-is-greater-than-given-criteria/)**