Excel Formulas to Map Inputs to Arbitrary Values ~ Easy Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-03-06 04:33:38

---
title: Excel Formulas to Map Inputs to Arbitrary Values ~ Easy Tutorial!!
published: true
date: 2021-03-05 11:46:22 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-map-inputs-to-arbitrary-values-easy-tutorial/
---

As we all known, the **VLOOKUP function** is used to look up the data or range by row. Today, we are going to look at how you can use the VLOOKUP function to **map the inputs to arbitrary values in Excel**. 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)

[![Map inputs to arbitrary values](https://geekexcel.com/wp-content/uploads/2021/03/Map-inputs-to-arbitrary-values.png)](https://geekexcel.com/excel-formulas-to-map-inputs-to-arbitrary-values-easy-tutorial/map-inputs-to-arbitrary-values/#main)<figcaption id="caption-attachment-22289">Map inputs to arbitrary values</figcaption>
## General Formula:

- To map inputs and return the result as arbitrary values in Excel, you can use the below formula.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(input,map\_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/).
- **Input** – It represents the criteria value for the input values.
- **Map-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.

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

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-7.png)<figcaption id="caption-attachment-22290">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-8.png)<figcaption id="caption-attachment-22291">Enter the formula</figcaption>

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

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

## Bottom-Line:

Hope you like this article on how to **map inputs to arbitrary values in Excel**. If you have any issue regarding this article or any **unresolved**   **query** , please comment in the **comment** box below. We will assist you!! Thank You!! To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas Group Numbers with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-group-numbers-with-vlookup-function/)**
- **[Formulas to Sum the Values by Group in Excel Office 365!!](https://geekexcel.com/formulas-to-sum-the-values-by-group-in-excel-office-365/)**
- **[Excel Formulas Group Numbers with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-group-numbers-with-vlookup-function/)**