Excel Formulas: Faster LOOKUP with two VLOOKUPS!!
Tags: excelformula, excelformulas
Published: 2020-12-23 09:22:17

---
title: Excel Formulas: Faster LOOKUP with two VLOOKUPS!!
published: true
date: 2020-12-22 10:09:59 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-faster-vlookup-with-two-vlookups/
---

With large sets of data, exact match VLOOKUP can be painfully slow, but you can make VLOOKUP lightning fast by using two VLOOKUPS, as explained below. 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)

[![Formulas to faster lookup with 2 VLOOKUPS](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-faster-lookup-with-2-VLOOKUPS.png)](https://geekexcel.com/excel-formulas-faster-vlookup-with-two-vlookups/formulas-to-faster-lookup-with-2-vlookups/#main)<figcaption id="caption-attachment-20196">Formulas to faster lookup with 2 VLOOKUPS</figcaption>

## Generic Formula:

- Use the below formula for faster Lookup.

**=[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/)(range,data,1,[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/))=range, VLOOKUP(criteria,data,column,TRUE), [NA](https://geekexcel.com/how-to-use-excel-na-function-in-office-365-with-examples/)())**

## Syntax Explanations:

- **IF-** The Excel** [IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** return one value for a TRUE result, and another for a FALSE result.
- **VLOOKUP** – This function will 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/)**.
- **TRUE** – In Excel, the **[TRUE function](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** will help to return the value TRUE if the given conditions will be TRUE.
- **NA** -NA means “ **Not Available** ” or “ **No**   **value**   **available”**. Read more on the **[NA Function](https://geekexcel.com/how-to-use-excel-na-function-in-office-365-with-examples/)**.
- **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.
- **Data** – It represents the input ranges in your worksheet.
- **Column** -It denotes the column number.

## Practical Example:

- Let’s see the below screenshot to get the faster VLOOKUP with 2 VLOOKUP Function.
- Here, we will give the input values in **Column B** to **Column E**.
- Then, enter the given formula in the formula bar section.
- Finally, we will get the results in selected **cell H4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-74.png)<figcaption id="caption-attachment-20197">Example</figcaption>

## Conclusion:

Hope you understood how to get the faster LOOKUP with two VLOOKUPS 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. To learn more, check out **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[How to Vlookup Values from Bottom to Top in Excel 365?](https://geekexcel.com/how-to-vlookup-values-from-bottom-to-top-in-excel-365/)**
- **[Excel Formulas to Extract Multiple Matches into Separate Rows!!](https://geekexcel.com/excel-formulas-extract-multiple-matches-into-separate-rows/)**
- **[Formulas to Vlookup Values from Bottom to Top in Excel 365!!](https://geekexcel.com/formulas-to-vlookup-values-from-bottom-to-top-in-excel-365/)**