Using VLOOKUP to create interactive map dashboards in MS Excel

Here is one of four videos demonstrating how the interactive map dashboard was set up MS Excel. This focuses on the use of VLOOKUP to create a summary dashboard that is updated on click of the country with data from the source table. This tutorial assumes a basic familiarity with the =VLOOKUP function and goes straight to demonstrate its application with minimal background. I also demonstrate practical application of two other Excel functions: =TEXT and =CONCATENATE. Remember to like, share