Excel Formulas: Multiple Chained VLOOKUPs ~ Simple Guide!!
Tags: excelformula, excelformulas
Published: 2021-01-22 03:50:10

---
title: Excel Formulas: Multiple Chained VLOOKUPs ~ Simple Guide!!
published: true
date: 2021-01-21 12:05:16 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-multiple-chained-vlookups/
---

In Excel, sometimes we need to perform multiple lookups sequentially, based on the given criteria. In this case, we need to check the values whether the earlier lookups succeed or not. Here, we come up with some tricky tips to solve this job. Let’s see how to find the **multiple chained VLOOKUPs in Excel**? 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)

[![Multiple chained Vlookups](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Multiple-chained-Vlookups.png)](https://geekexcel.com/?attachment_id=21307#main)<figcaption id="caption-attachment-21307">Multiple chained Vlookups</figcaption>

## Generic Formula:

- Use the below formula to look up the values in multiple tables.

**=[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/) 1 ,IFERROR(VLOOKUP 2,VLOOKUP 3))**

## Syntax Explanations:

- **VLOOKUP** – The **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** helps to lookup data in a range or table by row.
- **IFERROR** – This function will 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/)**.
- **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 get the multiple chained lookups.

- First, we will enter the input data.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-16.png)<figcaption id="caption-attachment-21300">Input Ranges</figcaption>

- Here we need to find the color based on the given ID.
- So, enter the above-given formula into 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/01/Enter-the-formula-19.png)<figcaption id="caption-attachment-21301">Enter the formula</figcaption>

- It will look up the value from the input tables and return the result to the selected cell.

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

## Wrap-Up:

Hope you understood how to look up the value from the **multiple chained table in Excel** by using the VLOOKUPs. 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:

- **[Excel Formulas to Merge the Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-merge-tables-with-vlookup/)**
- **[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/)**
- **[Excel Formulas to Find the Approximate Match with Multiple Criteria!!](https://geekexcel.com/excel-formulas-find-approximate-match-with-multiple-criteria/)**