Hi, I basically want to create a drop down where you can select an age group and it simply lists the top 20 medical conditions in one column, number of admissions last year and this year, in the next two columns.
Basically I have five tables by age group - 20s, 30s, 40s, 50s, 60s
For each table, the column headings are Medical Condition (where the rows contain the list of the types of conditions), column 2016/17 YTD (rows containing the number of admissions for each condition), and column 2017/18 YTD (again, listing the number of admissions for each condition).
I have created Defined Name for each of the five tables - (I.e defined names are the age groups).
I then created a drop down list of the Defined Names - (which are the five age groups).
I now want to create a separate table which includes the list of top 20 medical conditions (and corresponding activity) for whichever age group you select from the toggle.
I thought it would be as simple as doing =index($b$4,3,1), where $B$4 refers to drop down which contains the Defined names (I.e the age group) I have just created. The 3 would refer to the third row, and 1 referring to the first column.
(I would have therefore created a whole table so then it would refer to the exact position, but the data would change according to the drop down toggle).
Why does it not pick up $B$4 as the array or Defined name.
How else can I crack this nut? Your help would be much appreciated
Basically I have five tables by age group - 20s, 30s, 40s, 50s, 60s
For each table, the column headings are Medical Condition (where the rows contain the list of the types of conditions), column 2016/17 YTD (rows containing the number of admissions for each condition), and column 2017/18 YTD (again, listing the number of admissions for each condition).
I have created Defined Name for each of the five tables - (I.e defined names are the age groups).
I then created a drop down list of the Defined Names - (which are the five age groups).
I now want to create a separate table which includes the list of top 20 medical conditions (and corresponding activity) for whichever age group you select from the toggle.
I thought it would be as simple as doing =index($b$4,3,1), where $B$4 refers to drop down which contains the Defined names (I.e the age group) I have just created. The 3 would refer to the third row, and 1 referring to the first column.
(I would have therefore created a whole table so then it would refer to the exact position, but the data would change according to the drop down toggle).
Why does it not pick up $B$4 as the array or Defined name.
How else can I crack this nut? Your help would be much appreciated
