Beautiful and Interactive Map Chart in Excel with Drop Down List | Index and Match Function скачать в хорошем качестве

Beautiful and Interactive Map Chart in Excel with Drop Down List | Index and Match Function

In this Excel video tutorial, we gonna learn how to create a Interactive Map Chart in Excel with a drop down list with options. Whenever you choose a new option in the list, the map is automatically update with the new values. So, in this video we gonna see how to do a data validation in Excel, how to create a option list in Excel. And, moreover, two function is gonna be needed to built this interactive Excel Chart. Index function and Match function in Excel. We gonna use both together, so it's called nested function, we gonna append one function to another. One formula within another formula. One function within another function. The MATCH function in Excel searches for a specified value in a range of cells. Then, it returns the relative position of that value in the range. For example, if the range A1:A10 contains a sequence of values that goes from 10 up to 20, and you need to know in what row the number 15 is at. So, the match function returns the number 5 as result, because the value that matches with the criteria is in the fifth row. The Index function in Excel, returns as result the value of a specific cell in a range, either a range of rows or columns. Combining the index function with the match function, we can built the interactive excel map chart. #JopaExcel #Dashboard #Excel