IFNA or IFERROR VLOOKUP Across Multiple Worksheets in Excel

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍

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
------------------------

[chugs]

i normally use =if(iserror which is basically the same but i was completely unaware that =ifna( can be stacked like you did. Wow. You've saved me literally hours of my life Chester

[lianaclarke]

Thank you for this explanation Chester.

[shelleychaplin]

Do you have a vlookup video where the lookup value already contains a vlookup formula that previously looked for that data, can't seem to find one - thanks

[excellence_is_me]

How to add values from different sheet of Sam'me item??