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