DEV Community

loading...

Excel Formulas: Multiple Chained VLOOKUPs ~ Simple Guide!!

excelgeek profile image Andrews Originally published at geekexcel.com on ・2 min read

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

Multiple chained Vlookups
Multiple chained Vlookups

Generic Formula:

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

=IFERROR(VLOOKUP 1 ,IFERROR(VLOOKUP 2,VLOOKUP 3))

Syntax Explanations:

  • VLOOKUP – The VLOOKUP function 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.
  • 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
Input Ranges

  • Here we need to find the color based on the given ID.
  • So, enter the above-given formula into the formula bar section.

Enter the formula
Enter the formula

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

Result
Result

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!! And Excel Formulas!!

Read Also:

Discussion (0)

pic
Editor guide