I want to use a table on a dashboard. Problem is the table has a large number of rows. I want to use slicers as filters with the table and make the table scrollable on another sheet (i.e my dashboard). My problem is that if I scrollbar the slicers and the scrollbar seems to get mixed up. I have the following formula in the scrollable table on the dashboard : =INDEX(Lande!$B$2:$B$45426,TableKultivarWereld2000tot2016!$U$1)
I tried to change the first reference in the index to : =INDEX(INDIRECT("Lande!B"&$U$3 &":B$45426" ),TableKultivarWereld2000tot2016!$U$1), but that does not give the correct value for the second row in my scrollable table.
I think I have to put the filtered range for the reference, but cannot figure out how to do that. Perhaps with a aggregate function using 10 ,5,Column?
Any help would be much appreciated.
Regards
