Excel Formulas to VLOOKUP with Numbers and Text ~ Easy Steps!!
Tags: excelformula, excelformulas
Published: 2021-02-15 05:30:47

---
title: Excel Formulas to VLOOKUP with Numbers and Text ~ Easy Steps!!
published: true
date: 2021-02-13 11:21:06 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-vlookup-with-numbers-and-text-easy-steps/
---

So far we have learned many formulas based on the Excel **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**. On this page, we come with the new formula to **find out numbers and text in Excel by using the VLOOKUP function**. Let’s get into this article!! 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)

[![Vlookup with numbers and text](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Vlookup-with-numbers-and-text.png)](https://geekexcel.com/excel-formulas-to-vlookup-with-numbers-and-text-easy-steps/vlookup-with-numbers-and-text/#main)<figcaption id="caption-attachment-21846">Vlookup with numbers and text</figcaption>
## Generic Formula:

- Use the below formula to retrieve information from the table where the key values are numbers stored as text.

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(id,table,column,0),VLOOKUP(value&””,table,column,0))**

## Syntax Explanations:

- **IFERROR** – It helps to return a custom result when a formula generates an error and a standard result when no error is detected. Read more on the **[IFERROR function](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)**.
- **VLOOKUP** – This function will help to lookup 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/)**.
- **Value** – It is the specific criteria to find the values.
- **Table** – It contains the input values from your worksheet.
- **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.

## Practical Example:

Let’s see how to retrieve the numbers and text in Excel.

- First, we will enter the input values in **Column B** to **Column E**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-Ranges-8.png)<figcaption id="caption-attachment-21847">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.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-11.png)<figcaption id="caption-attachment-21848">Enter the formula</figcaption>

- Finally, it will display the result in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-14.png)<figcaption id="caption-attachment-21849">Result</figcaption>

## Bottom-Line:

From this short tutorial, you can get some clarification on how to **look up the value based on numbers and text in Excel by using the VLOOKUP function**. If you feel this article is useful, then leave **feedback** in the below **comment** section. 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 Lookup Multiple Criteria with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-lookup-multiple-criteria-vlookup-function/)**
- **[Excel Formulas to VLOOKUP by Date ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-vlookup-by-date/)**