IFNA or IFERROR VLOOKUP Across Multiple Worksheets in Excel

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell

Please support our Sponsors here :