Excel Formulas to VLOOKUP Override Output ~ Useful Guide!!
Tags: excelformula, excelformulas
Published: 2021-02-13 06:50:46

---
title: Excel Formulas to VLOOKUP Override Output ~ Useful Guide!!
published: true
date: 2021-02-12 09:12:41 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-vlookup-override-output-useful-guide/
---

Normally, the [**VLOOKUP function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) is used to retrieve data from a specific row. There are lots of amazing tricks available in the VLOOKUP function. In this article, we will show you **how to override the output from the VLOOKUP Excel?** Let’s step 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 override output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/VLOOKUP-override-output.png)<figcaption id="caption-attachment-21795">VLOOKUP override output</figcaption>

## Generic Formula:

- To override output in Excel, you can use the below formula.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)()=x,y,VLOOKUP())**

## Syntax Explanations:

- **IF** – The **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** helps to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result
- **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/)**.
- **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:

Refer to the below example image. Here we are going to override the result.

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

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

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

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-8.png)<figcaption id="caption-attachment-21791">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-11.png)<figcaption id="caption-attachment-21793">Result</figcaption>

## Wrap-Up:

Hope you like this article on **VLOOKUP override output**. If you have any **questions** , feel free to **comment**. We will assist you. To learn more, check out  **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas: Faster LOOKUP with two VLOOKUPS!!](https://geekexcel.com/excel-formulas-faster-vlookup-with-two-vlookups/)**
- **[Excel Formulas to VLOOKUP by Date ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-vlookup-by-date/)**