Chibikitsuneluna
New Member
- Joined
- Jul 13, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Currently using =FILTER('CEREDIGION CASELOAD'!$B$2:$B$2049,'CEREDIGION CASELOAD'!$AG$2:$AG$2049=$A$1,"") in A3, then =IFERROR(INDEX(Caseload[Name],MATCH(A3,Caseload[CRN],0)),"") in B3, =IFERROR(INDEX(Caseload[Surname],MATCH(A3,Caseload[CRN],0)),"") in C3; etc to pull the data from the Caseload sheet.
I need to be able to sort this data by column K which has =IFERROR(INDEX(Caseload[Appointment Month],MATCH(A3,Caseload[CRN],0)),"") in K3.
Any help much appreciated.
I need to be able to sort this data by column K which has =IFERROR(INDEX(Caseload[Appointment Month],MATCH(A3,Caseload[CRN],0)),"") in K3.
Any help much appreciated.