In today’s video, we explore how to: * use VLOOKUP in another worksheet in Excel VBA * replace the default and boring N/A error with a custom message like "Not Found" * color missing values in red for better readability * display a message box showing exactly how many values haven't been found #excel #vbatutorial #automation #vbaprogramming If you have questions or ideas for future videos, just leave a comment below. And if this was useful, please like the video and consider subscribing for more Excel, VBA and Python data automation and analytics tutorials. You can also visit my site to check out some of my hobby projects: