Hello all
I have a formula shown below -
=(COUNTIFS(ArtRawData[Pupil Premium Indicator],"Y",ArtRawData[Prior Attainment Band],"High",ArtRawData[Know Progress Art 4 Y7 Assessment 4],"Above Expected Progress")+COUNTIFS(ArtRawData[Pupil Premium Indicator],"Y",ArtRawData[Prior Attainment Band],"High",ArtRawData[Know Progress Art 4 Y7 Assessment 4],"Expected Progress"))/E24
The ArtRawData refers to a table in another sheet with [Pupil Premium Indicator] being the column reference. What I would like to do is to be able to select the table dynamically based on another cell so that I can have the user select the table they want in the formula from a list.
I have had a look at INDIRECT but I cannot work it out. Any help would be greatly appreciated.
Thanks
I have a formula shown below -
=(COUNTIFS(ArtRawData[Pupil Premium Indicator],"Y",ArtRawData[Prior Attainment Band],"High",ArtRawData[Know Progress Art 4 Y7 Assessment 4],"Above Expected Progress")+COUNTIFS(ArtRawData[Pupil Premium Indicator],"Y",ArtRawData[Prior Attainment Band],"High",ArtRawData[Know Progress Art 4 Y7 Assessment 4],"Expected Progress"))/E24
The ArtRawData refers to a table in another sheet with [Pupil Premium Indicator] being the column reference. What I would like to do is to be able to select the table dynamically based on another cell so that I can have the user select the table they want in the formula from a list.
I have had a look at INDIRECT but I cannot work it out. Any help would be greatly appreciated.
Thanks
