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
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.
- Here we need to find the color based on the given ID.
- So, enter the above-given formula into the formula bar section.
- It will look up the value from the input tables and return the result to the selected cell.
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!!
Top comments (0)