Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/11/VLOOKUP-Across-Multiple-Worksheets-Using-IFNA.xlsx

In this video I demonstrate how to perform a VLOOKUP across multiple worksheets. The solution requires a combination of either the IFERROR and VLOOKUP functions or the IFNA and VLOOKUP functions.

There are some alternate ways you can use this combination of functions:

Table of Contents:

00:00 - Combine IFNA (or IFERROR) and VLOOKUP to lookup across multiple worksheets
04:23 - Use named references instead of range references
07:01 - Use Excel tables to create a dynamic range
------------------------