weranut.blogg.se

How to do a drop down menu in excel 2016 youtube
How to do a drop down menu in excel 2016 youtube











how to do a drop down menu in excel 2016 youtube how to do a drop down menu in excel 2016 youtube

For the row_num parameter, the lookup value is the App name on the data preparation table (P5) and the lookup_array is $B$5:$B$9.The syntax of the MATCH() function is: = MATCH(lookup_value, lookup_array,match_type) The MATCH() function will be used to find the Month at the raw data table. column_num – how many columns to the right.The MATCH() function will be used to find the App name at the raw data table. array – the area where the answer can be found, $C$4:$N$9.The syntax of the INDEX() function is: = INDEX(array, row_num, ) The easiest way to do it is to use Excel’s INDEX() and MATCH() functions in finding the answer. Proceed to extracting the correct data set by using the combination of the App name and month selected. Use a cell reference to the selected Month as the header of the Data Preparation Table. Otherwise, you can make this dynamic by using cell references. In this case, we will assume that the App names are fixed and unchanging and all you have to do is copy them over to the Data Preparation table and sort them alphabetically. To set it up, you will need your App names as the first column.

how to do a drop down menu in excel 2016 youtube

Once the user selects a month, the data preparation table should display the data corresponding to that month for each App.













How to do a drop down menu in excel 2016 youtube