IFNA or IFERROR VLOOKUP Across Multiple Worksheets in Excel

nnnn

Microsoft Excel Tips and Tricks

nIn 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.nnnn

Credit Chester Tugwell

n

Leave a Reply

Your email address will not be published. Required fields are marked *