DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel Formulas To Map Text to Numbers ~ Easy Tutorial!!

In the previous post, we have learned how to map inputs to arbitrary values in Excel. 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

Map text to numbers
Map text to numbers

Generic Formula:

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

=VLOOKUP(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.
  • 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
Input Ranges

  • Then, apply the above-given formula to the formula bar section and press the “Enter” key.

Enter the formula
Enter the formula

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

Result
Result

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 *and Excel Formulas *!!

Read Also:

Top comments (0)